OraFAQ Forum: SQL & PL/SQL » URGENT!! Lenght of the data

Home » SQL & PL/SQL » SQL & PL/SQL » URGENT!! Lenght of the data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

URGENT!! Lenght of the data [message #21641]

Wed, 21 August 2002 04:10

Karri
Messages: 33
Registered: May 2001

Member

Hi,
I have column(varchar2(200). There is different kind of data, (lenght between 3...150). How I can Select lenght of the each data row. I try LEN and LEGHT, but it didn't work.
BR Karri

Report message to a moderator

Re: URGENT!! Lenght of the data [message #21643 is a reply to message #21641]

Wed, 21 August 2002 05:14

Mike T
Messages: 32
Registered: August 2002

Member

If you are getting 200 back for a length, the field may be padded with spaces. Use:

LTRIM(RTRIM(LENGTH(field_name)))

to trim off the leading and trailing spaces.

Report message to a moderator