Home Page for the TeradataForum

Archives of the TeradataForum

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

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

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"
        FROM DUAL;

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.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016