I have a column in an Access Table that contains text data. I'm writing a
query and want to remove all spaces in the column. Trim will remove the
leading and trailing ones, but is there a way to remove all the blanks. For
example if the column contain ' A B C ' I would want 'ABC' returned.

JC

"tt" <tt@2> wrote

Hi JC,

A good place to start might be the Replace( ) function.

Replace(" A B C ", " ", "") will return "ABC"

But, you might want to check out how this function will handle non-space
'white space' characters like tabs and line feeds. I suspect you may need
something a little stronger or need to tweak Replace( ) a bit.

Hope this helps,
John MacIntyre
VC++ / VB / ASP / Database Developer
http://www.johnmacintyre.ca