TRIM FUNCTION in QUERY

  • Thread starter Thread starter Cam
  • Start date Start date
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) ????
 
Back
Top