 |
 |
Archives of the TeradataForum
Message Posted: Thu, 28 Apr 2005 @ 14:40:41 GMT
| Subj: | | Re: SQL using Ltrim function |
| |
| From: | | Prescott, Kyle R |
LTRIM and RTRIM are not supported. Use TRIM(LEADING FROM col_i) in lieu of LTRIM and TRIM(TRAILING FROM col_i) in lieu of RTRIM.
I believe they are in the Teradata ODBC driver and will parse be converted to the appropriate supported string function, but not officially
supported in the RDBMS so you may have compatibility issues with them.
Kyle Prescott
UnumProvident, Data Strategies
| |
