Report # of characters for an integer value

Question

Report # of characters for an integer value

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

gpeters (9/10/2008)
Chris Morris (9/10/2008)
I've just run this again, exactly as it appears here...
Strange. What type of db are you using?

You first 😉

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

gpeters SSC Veteran Points: 247 More actions · Answer 2

Chris Morris (9/10/2008)
gpeters (9/10/2008)
Chris Morris (9/10/2008)
I've just run this again, exactly as it appears here...
Strange. What type of db are you using?
You first 😉

tried oracle & sybase

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

It works on SQL Server 2k, and I'm pretty sure it will work in SQL Server 2k5 too. This is a SQL Server 2k5 forum section.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

gpeters SSC Veteran Points: 247 More actions · Answer 4

Chris Morris (9/10/2008)
It works on SQL Server 2k, and I'm pretty sure it will work in SQL Server 2k5 too. This is a SQL Server 2k5 forum section.

Thanks Chris. I'll re-examine the code to work in Sybase.

Monica Chaturvedi SSC Journeyman Points: 80 More actions · Answer 5

I guess Convert(Len()) does it all

Ex:

select Convert(varchar,len(-1234.55))