remove spaces between words. replace() not working

  • Thread starter Thread starter mapsNoob
  • Start date Start date
M

mapsNoob

I am trying to remove spaces between words in the db and replace does
not seem to be working.
I used it in the query window. may be I am not entering it properly.
my query:
select replace(field, ' ',' ')
from tableName

does not execute without "select".

Thanx for the help in advance.
 
Do you want to update your field or just display the results where two spaces
are displayed as one space?
"execute" is generally associated with action queries such as UPDATE, MAKE
TABLE, APPEND, or DELETE queries.
 
Back
Top