General discussion

Locked

Remove spaces from a string

By afisher ·
I'd like to remove all of the spaces from every string value contained in a particular column of an Access 97 table. I'd like something a little easier than looping through a DAO recordset, but that will do if someone can help me with the code as I'm a bit rusty. Thanks!

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sjohnson175 In reply to Remove spaces from a stri ...

I can't remember if Access supports all of ANSI SQL but:

UPDATE table SET column = REPLACE(column, " ", "")

Collapse -

by sjohnson175 In reply to

Oops! should be using single quotes, not double. Sorry.

UPDATE table SET column = REPLACE(column, ' ', '')

Collapse -

by afisher In reply to

Poster rated this answer.

Collapse -

by afisher In reply to Remove spaces from a stri ...

This question was closed by the author

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums