I have some problems with Length calculating function in TERADATA. I am using Teradata SQL Assistant 13.11.0.05, some of my colleges are using version 7.????.
I cannot use the LENGTH function but the CHARACTER_LENGTH and the CHARACTER functions are working ok. I cannot us the LENGTH function in version 13. I get the following error:
SELECT LENGTH(' ABC ');
SELECT FAILED.  Syntax error expected something between ‘(‘ and a string or a Unicode literal.
My college has both Assistant version 13 and 7 installed. He had problems with the version 7 where the LENGTH function was not working. I have only installed Assistant 13 and I cannot make the LENGTH work. The 2 other are working fine:
SELECT CHARACTERS(TRIM(TRAILING FROM ' ABC '));
SELECT CHARACTER_LENGTH(TRIM(TRAILING FROM ' ABC '));
Thanks for the information. Glad I alwas has been using the CHARACTER_LENGTH function.
I will update my coworkers.