STR

Question

Post reply

STR

Ravi SQL

SSCommitted

Points: 1714
More actions
October 17, 2012 at 9:24 pm

#265795

Comments posted to this topic are about the item STR
Regards,
Ravi.

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Thanks, always nice to be reminded of the basics ...

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

demonfox SSCertifiable Points: 6289 More actions · Answer 2

A new one for me ...

thanks

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

kapil_kk SSC-Insane Points: 21316 More actions · Answer 4

new things for me...

thanks

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

kalyani.k478 Default port Points: 1400 More actions · Answer 5

kalyani.k478

Default port

Points: 1400

October 18, 2012 at 12:29 am

#1550306

Easy point! thanks..

Divine Flame SSCoach Points: 15943 More actions · Answer 6

Divine Flame

SSCoach

Points: 15943

October 18, 2012 at 1:26 am

#1550315

Nice question. Thanks!

Sujeet Singh

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 7

I knew about the STR function, but was not entirely sure what the optional arguments meant, so I decided to check Books Online before answering.

I must say that I was a bit surprised to see an example that is EXACTLY identical to today's question...

Coincidence?

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Stuart Davies SSCoach Points: 19505 More actions · Answer 8

Hugo Kornelis (10/18/2012)
I must say that I was a bit surprised to see an example that is EXACTLY identical to today's question...
Coincidence?

You cynic Hugo. 😛

But if the question serves to educate, test or whatever - I don't see the harm

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 9

I initially thought '23.45' as I would have thought the length requirement of 2 would 'count' from the smallest to the largest unit, but decided to test the statement before answering. I was surprised to get **, was not aware of this element of STR. An undeserved point for me, I think. Thanks for the question.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

TomThomson SSC Guru Points: 104773 More actions · Answer 10

Good question

But the explanation is very poor, inaccurate. For example the length of the expression "123.45" is 6, but str(123.45,4,2) is not '**' as suggested by the explanation but '123'.

Tom

@Cassie SSC Eights! Points: 890 More actions · Answer 11

Good thing that it is "**"

Wrong information is no information.

Divine Flame SSCoach Points: 15943 More actions · Answer 12

Hugo Kornelis (10/18/2012)
I knew about the STR function, but was not entirely sure what the optional arguments meant, so I decided to check Books Online before answering.
I must say that I was a bit surprised to see an example that is EXACTLY identical to today's question...
Coincidence?

I don't think it is coincidence :hehe: but no problem as the question servers the purpose.

Other benefit is that the author of the question has an "exact" explaination available on msdn 😀

Sujeet Singh

@Cassie SSC Eights! Points: 890 More actions · Answer 13

L' Eomot Inversé (10/18/2012)
Good question
But the explanation is very poor, inaccurate. For example the length of the expression "123.45" is 6, but str(123.45,4,2) is not '**' as suggested by the explanation but '123'.

It is an exact copy from the http://msdn.microsoft.com/en-us/library/ms189527(v=sql.100).aspx, first example!

TomThomson SSC Guru Points: 104773 More actions · Answer 14

@Cassie (10/18/2012)
L' Eomot Inversé (10/18/2012)
Good question
But the explanation is very poor, inaccurate. For example the length of the expression "123.45" is 6, but str(123.45,4,2) is not '**' as suggested by the explanation but '123'.
It is an exact copy from the http://msdn.microsoft.com/en-us/library/ms189527(v=sql.100).aspx, first example!

The examples on that page contain no explanations, so how can the explanation be an exact copy of something in one of them? Also, the length and decimal parameters are not the ones in the first example, but the ones in the second.

I guess the real point is that the length of '123.45' is irrelevant to whether '**' turns up, all that is relevant is the length of '123', since str is perfectly happy, if neccessary to get a result other than '**', to thow away everything after the decimal point and ignore the decimal argument of str. This is made absolutely clear by the text onm the page you refer to.

Incidentally, your link points to 'Microsoft Website': you have the display text and the URL the wrong way round. That makes it not a useful clickable link; doesn't matter as the display text tells us where to go.

Tom