I need to replace all instances of the character within all the records

many thanks Rohit, that works great

ok thanks,  will try and learn how to do it if I can

It's something I'd like to learn/play around with, even if it's something I wouldn't use

Thanks Jeff, as always you guys come up trumps, your post is very informative and has helped a lot. Any information you come up with will be great. Thanks again

Jeff, any chance you can show me how the IDENTITY column works?

thanks for the input guys

that appears to work ok, thanks for the response

Thanks Jason, that's a great help

is it possible to set the server timeout in vb code? or in a stored procedure?

Thanks Jason

thanks people, the sp that Jason posted was exactly what I needed. What would people like me do without people like you. Thanks again

thanks for the quick reply Peter, unfortunatly it didn't work

many thanks for the info

Thanks Jason, I more or less made my mind up to do just that. I couldn't see any easier way of doing it