SQL command to replace value

[davidmcolaco]

Hi,

I have a table where I want to change all the records that contains A in a field to B.
How can I do that sql command?

Thanks.

 

[pmcmicha]

If the column that contains A is all alone then it is fairly easy:

update TABLE1 set COL1='B' where COL1='A'


If this is not the case, then I suggest trying a forum where SQL gurus reside.