Archives of the TeradataForum

Message Posted: Tue, 27 Jul 2004 @ 13:18:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

     SELECT LENGTH('CANDIDE') "Length in characters"
        FROM DUAL;

Just use this the same query without the FROM clause:

     SELECT LENGTH('CANDIDE') "Length in characters" ;

             Length in characters
             7

I think there shouldn't be any problems with LENGTH as such. If you are interested in the Teradata DUAL counterpart check out the very extensive thread we had on DUAL last week.

Regards,

Victor

	<Prev	Next>		<<First	<Prev	Next>	Last>>