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
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
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
Adithya |