Length of a string

[Jess.mic]

How do we find out the length of string??

[nnani]

Hello Jess

Vertica provides a function to count the length of a string
The function is "length"

Code: Select all

nnani=> select length('jess.mic') from dual;
 length
--------
      8
(1 row)

Hope this helps.