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
This question is marked "community wiki".
asked 25 Jun '12, 08:25 Adithya |
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 answered 25 Jun '12, 08:51 Breck Carter |
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. answered 25 Jun '12, 10:09 Adithya |