remove spaces between words. replace() not working

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.
 
D

Duane Hookom

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.
 
Top