Remove whitespace from a Columns values

[d4n0]

Hi,

I need to remove whitespace from all the values in a certain column in a table.

I want to do something like:

update myTable
set colName = trim(colName)

but that's not doing the trick. Any suggestions?

Cheers,

Dan.

 

[JayKusch]

Define "whitespace" for us.

Thanks

J. Kusch

 

[Jamfool]

UPDATE table_name set column_name = REPLACE(column_name, ' ', '')


replaces the first quoted with the 2nd quoted e.g a space with nothing