Integer lengths (I)

Question

Integer lengths (I)

TomThomson

SSC Guru

Points: 104773
More actions
June 29, 2015 at 9:31 pm

#299529

Comments posted to this topic are about the item Integer lengths (I)
Tom
June 30, 2015 at 4:33 am

This was removed by the editor as SPAM
July 1, 2015 at 2:47 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 20 total)

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

sarah.ryan Valued Member Points: 71 More actions · Answer 1

Surely this question is less about integer lengths and more about string conversions?

What it's really drawing attention to is that str(), which produces a fixed length string, left pads on conversion, while cast/convert right pad a fixed length string. This happens regardless of whether the input is an integer.

Good question though - certainly highlighted something I was unaware of - glad I always opt for explicit type conversions

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 2

Great question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 3

Nice,failed due to the right justified result of STR.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Well done, Tom. Not only way it clear, concise and correct, it made me think it through, which is always good. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

free_mascot One Orange Chip Points: 27164 More actions · Answer 5

Nice question, thanks Tom.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Ken SSCoach Points: 17191 More actions · Answer 6

Nice question Tom. I haven't used the STR() function before.

cgumprich Ten Centuries Points: 1060 More actions · Answer 7

cgumprich

Ten Centuries

Points: 1060

June 30, 2015 at 7:02 am

#1809102

Good one. Learned something by getting it wrong.

RLilj33 SSCrazy Points: 2153 More actions · Answer 8

Stewart "Arturius" Campbell (6/30/2015)
Nice question, thanks Tom
Never been fond of the STR() function myself, as i prefer explicit cast/convert

+1. My thoughts exactly.

webrunner SSC-Dedicated Points: 31938 More actions · Answer 9

Cool question, thanks.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html