Update statement

[angelagke]

how to write update SQL statement in order to remove all underline in my data for each field, example: "HIGH COST___" change to "HIGH COST" which is remove the underline for all data.. Thanks angela

[Dinuj Nath]

Update table1 set col1 = replace(col1,'_','') -- Don't take life seriously because you can't come out of it alive. -Warren Miller (From Monty2[^] bio)

[angelagke]

ok, i get it :) Thanks a lot for help, Dinuj Nath ;) angela

[VK Cadec]

How about:: Update table1 set col1 = 'HIGH COST'

[angelagke]

I think the previous 'replace' sql statement is more suitable for me because the data that I wanted to remove those underline have different value, not just for 'HIGH COST' only :) Anyway, thanks again for your suggestion.;) angela