Can i use LEN() 4

[Deleco]

Hi All,

Can i use LEN in ORACLE SQL. If so does the data have to be of string type? If yes is there a convert to string function. I have numeric values in a field e.g. 8, 88, 888, 8888 and i would like to know how long they are.

Many thanks for help in advance
Deleco

Deleco

 

[Dagon]

There's a LENGTH function, which will work on numeric datatypes. I'd normally convert the datatype before using it e.g. length(to_char(number)).

 

[Deleco]

That worked a TREAT thanks very much.....

Deleco

 

[SantaMufasa]

Deleco,

If it was that good and helpful, it probably deserves a "Thank Dagon for this valuable post!", right?

Mufasa
(aka Dave of Sandy, Utah, USA @ 15:24 (06Oct04) UTC (aka "GMT" and "Zulu"), 08:24 (06Oct04) Mountain Time)

 

[Dagon]

Yes, I could do with a few stars at the moment. All those that I had collected up to now seem to have been wiped out and I'm starting from scratch again.

 

[KenCunningham]

There you go!!!

 

[Deleco]

Done, no problem and thanks for the TIP. Worked a treat

Deleco