LEN()

Question

LEN()

Viewing 3 posts - 16 through 17 (of 17 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Thanks for the QOD

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

antony-688446 Ten Centuries Points: 1221 More actions · Answer 2

Made me question the way char's are handled in len() as we always use varchar, so thanks!

Dhruvesh Shah SSCrazy Points: 2303 More actions · Answer 3

i thought ans would be 5 2 3 but as it wasn't present i have to search and found that space is ignored

would have been better if we have option of 5 2 3. many of us would have got that wrong