E
Eli
Is there an Access function that I could use within a SELECT query to
remove spaces from the contents of a text field? This is in
Access2000 called through an ODBC driver.
I'm not looking to trim just leading or trailing spaces. I need to
remove all spaces from the text.
SELECT SomeAccessFunction(mytextfield) AS nospaces
FROM mytable
remove spaces from the contents of a text field? This is in
Access2000 called through an ODBC driver.
I'm not looking to trim just leading or trailing spaces. I need to
remove all spaces from the text.
SELECT SomeAccessFunction(mytextfield) AS nospaces
FROM mytable