Help with formatting queries

[majordog]

Hi All,
I have a table with a plate column. In the data, there are records with spaces in them e.g. AAA 123 rather than AAA123 (or BBBB 12 rather than BBBB12) . I need to remove all these spaces. I'm looking for help as I'm not sure how to approach this. The spaces do not always occur in the same position.
Thanks - Sonia

 

[cristians]

HI

I have resolve the problem by opening the table and using Find and Replace
Find what " "
Replace With ""
Look in FieldName
Match in Any part of field

In Forms you can use replace function to exclude spaces

Bye

 

[majordog]

I actually found the answer - the 'replace' works beautifully:

update UserInfo
set phone = replace( phone, '-', '')