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) ????
 
Top