SQL Trim function



hi all..
i have a doubt...how we can remove blank spaces
in a column value while retrieving?
i tried using LTRIM(RTRIM(COLUMN NAME))...
But it's removing only the leading and trailing spaces...
how i can remove spaces in between?
anybody please help...
thanks and regards,

Van T. Dinh

If you are sure that they are space characters and not blank characters
(icluding tab, etc ...), you can use:

Replace([FieldName], " ", "")

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