Jeff, I’d like to take you up on your offer regarding Quirky Update. I’d appreciate some sample code regarding this. Many thanks for your patience, have a great weekend.

kind regards

Mick

Hi Jeff, no issues as such. It's just nice to find various alternatives to the same solution. I find them a great way of learning. As for Steve's suggestion of...

Thanks David, that's a great help. I don't suppose you know what Jeff means about a quirky update ?

Yes Jeff, Thanks

Thank you again Gentlemen, all those suggestions are great and gives me more to play with. I hadn't realised I could have fixed the 'problem' data as easy as that....

Will do, thanks Ed

Many thanks gentlemen, both solutions look good to me. I'm still learning SQL and these snippets are a useful way of adding to my knowledge. I'm going to try both...

Thanks Ed for that snippet, I can see many uses for it, unfortunately it's not quite what I was looking for.