Remove all spaces in a field - SQL

[RemingtonSteel]

Hello everyone!
I want to replace a field in SQL by removing all of the spaces.

Ex.

Field1 = ' Italy, France'

Desired Result - 'Italy,France'

Thanks.
Gene

 

[Mike Lewis]

Gene,

You could do this:

UPDATE MyTable SET MyField = STRTRAN(MyField, " ", "")

Not sure what you mean by a "a field in SQL", but I think the above will do what you want.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk