TRIM FUNCTION in QUERY

C

Cam

Hello,

What do I put to trim off the spaces after a value in query? The table is
obtained from ODBC link and the values on a field somehow got spaces. Example:

My field in the query is:
WC: PO_WORKCENTER_ID

Not sure
WC: TRIM(PO_WORKCENTER_ID) ????
 

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

TRIM function in query 2
TRIM function isn't working in my query 3
Trim in Query Error 1
Trim trailing spaces for name field in query 4
Need help with IIf and Trim$ function in a query 6
rtrim using the function a query 4
Trim function in a query 1
AND query 4

Top