updating part of the field.

[endedya]

Hi,
i am looking for a just simple sql statement to replace for e.g. 255 in 255754000000 by 0 in my table, so i want to do this in all my field,

i will appreciate if i get the answer in endedya@gmail.c om

[shaileshb]

ex. ur table name is TEMP10 with column "COL1" which contains following records

Select * From Temp10

Col1
-------------
2551001
2551002
2551003

now if u want to replace 255 just use update statement

Update TEMP10 Set COL1 = Replace(Col1, '255', '000')

[where condition]