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's gravatar image

Adithya
1113
accept rate: 0%


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
permanent link

answered 25 Jun '12, 08:51

Breck%20Carter's gravatar image

Breck Carter
27.4k424585838
accept rate: 21%

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.

permanent link

answered 25 Jun '12, 10:09

Adithya's gravatar image

Adithya
1113
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×90

question asked: 25 Jun '12, 08:25

question was seen: 858 times

last updated: 25 Jun '12, 10:09