LEN()

Question

Post reply

LEN()

Primo Dang

SSCrazy

Points: 2643
More actions
March 28, 2013 at 10:52 pm

#270481

Comments posted to this topic are about the item LEN()

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

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

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

Easy one for end of the week 😛

+1

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

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 2

Easy question, But unfortunately i selected wrong in hurry. :pinch:

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Whoops, Friday got me. Didn't put much thought in it and selected the wrong answer.

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

db4breakfast Ten Centuries Points: 1097 More actions · Answer 4

ahhh those trailing spaces. 🙂 thanks for the question.

--------------------------------------------------------------------------------------
Hai Ton
My Db4Breakfast blog.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 5

Nice question, on a seemingly simple, but not so, issue. Thanks!

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

TomThomson SSC Guru Points: 104773 More actions · Answer 6

Thomas Abraham (3/29/2013)
Nice question, on a seemingly simple, but not so, issue. Thanks!

Nice question.

It's surprising that nearly 40% (80 out of 203) answers are wrong. Some of that is just finger trouble (people just clicking in the wrong place) perhaps, but most of it must be people getting it wrong.

Tom

Dana Medley SSCertifiable Points: 6764 More actions · Answer 7

Great question. I was looking for the got'cha in this one, but never could find it and got it right.

Everything is awesome!

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 8

L' Eomot Inversé (3/29/2013)
Thomas Abraham (3/29/2013)
Nice question, on a seemingly simple, but not so, issue. Thanks!
... perhaps, but most of it must be people getting it wrong.

... and I am one of them.. at first... yea.. its easy.... 5 5 5.. after submitting (and before the actually answer displayed) ... "oh no ... it is datalength... not len.." 😀 (but inside... :crying:)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Venkat Jonnalagadda Mr or Mrs. 500 Points: 510 More actions · Answer 9

Thanks for the easy question to end the day... haha.. I got burnt with the LEN overlooking the leading spaces once...Good that I remember a lesson learnt in the past.....

___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:

Stephanie J Brown Hall of Fame Points: 3896 More actions · Answer 10

We don't use CHAR much, mostly NVARCHAR. My first thought was length of a CHAR field, as opposed to result of the LEN operation. Fortunately I re-thought before answering!:-P

Here there be dragons...,

Steph Brown

Revenant SSC-Forever Points: 42467 More actions · Answer 11

Revenant

SSC-Forever

Points: 42467

March 29, 2013 at 12:04 pm

#1602115

Thanks for this really nice one!

Primo Dang SSCrazy Points: 2643 More actions · Answer 12

I'm glad so many people enjoyed it, thank you! =]

I decided to submit this question when I saw this question from 2010[/url], because some people mentioned there should be an option involving leading spaces.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

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

TomThomson SSC Guru Points: 104773 More actions · Answer 14

Primo Dang (3/29/2013)
I'm glad so many people enjoyed it, thank you! =]
I decided to submit this question when I saw this question from 2010[/url], because some people mentioned there should be an option involving leading spaces.

That seems to be the wrong link - today's question, not a 2010 one.

Tom