How to find the length of a given number ??

[Former Member]

Hi All ,

Suppose I have a number -- 456712 . I have to get the length as - 6 as it contains 6 digits. Similary If I have a number - 456789098 - Output should be 9.

Is there any pre defined function to find out the length.

Or else let me know the approach.

Thanks, Adithya

[Breck_Carter]

SELECT CAST ( 456712    AS INTEGER ) AS x, LENGTH ( STRING ( x ) ) AS "Length of x"
UNION
SELECT CAST ( 456789098 AS INTEGER ) AS x, LENGTH ( STRING ( x ) ) AS "Length of x"
UNION
SELECT CAST ( 1000      AS INTEGER ) AS x, LENGTH ( STRING ( x ) ) AS "Length of x"

x,Length of x
456712,6
1000,4
456789098,9

[Former Member]

I got the answer after I thought for a long time.

1> select len(convert(varchar(30),123456)) 2>

---

       6

(1 row affected)

Let me know if anything wrong.