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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove space and chars. replace() does not work 2
Remove leading spaces 4
Replace third space with "-" 3
How to remove multiple symbols from a field 2
Formula to Remove Empty Spaces 9
Removing empty space character in cell 5
Remove Spaces 1
Capturing data from two tables... 5

Back
Top