SAS PROC SQL TRIM STATEMENT

I am having problems with a TRIM st

This is the error that I am receiving;

ERROR: CLI prepare error: [Teradata][ODBC Teradata Driver][Teradata Database]
     开发者_如何学Python  Syntax error, expected something like ')' between a string or a Unicode
       character literal and the integer '9'.

And this is a sample of the code it is refering to;

select trim(a.BR_CBS_CUST(FORMAT "9(4)")) || trim(a.STEM_CBS_CUST(FORMAT "9(6)")) || 
  trim(a.ACTP_CBS_CUST) || trim(a.CDG_CBS_CUST)  (char(20))as CUSTNO

Can anyone tell me what is wrong with the code?

Thanks.

Consider COMPRESS() which can be helpful when removing blanks and concatinating strings.

Did you try LTRIM RTRIM Instead normal Trim?