Archives of the TeradataForum
Message Posted: Tue, 27 Jul 2004 @ 13:18:45 GMT
| Subj: || || Re: String length function |
| From: || || Victor Sokovin |
| ||The following example uses the LENGTH function using a single-byte database character set:|| |
SELECT LENGTH('CANDIDE') "Length in characters"
Just use this the same query without the FROM clause:
SELECT LENGTH('CANDIDE') "Length in characters" ;
Length in characters
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.