Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and

Question

Post reply

Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and

June 5, 2014 at 7:23 am

This was removed by the editor as SPAM

Viewing 12 posts - 16 through 26 (of 26 total)

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

Thomas Abraham SSChampion Points: 10761 More actions · Answer 1

Worried a bit when I saw "easiest", due to the subjectivity involved. But, thanks for the question!

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

sestell1 SSChampion Points: 10230 More actions · Answer 2

Thomas Abraham (6/5/2014)
Worried a bit when I saw "easiest", due to the subjectivity involved. But, thanks for the question!

Yea, easiest for me generally means the most reliable and fault-tolerant, but it seemed pretty clear Gerald wanted us to pick the shortest/simplest solution.

Nice question BTW. 🙂

sknox SSChampion Points: 12388 More actions · Answer 3

Good question.

As usual, though, "easiest" translates to "how you should most often not do it".

If @TrueFalse is anything other than 'TRUE', 'FALSE', '', or an integer string, you'll get an error, and '' will return FALSE and not NULL.

So use this method if and only if you can be absolutely sure that @TrueFalse will never be anything but 'TRUE' or 'FALSE'.

RLilj33 SSCrazy Points: 2153 More actions · Answer 4

RLilj33

SSCrazy

Points: 2153

June 5, 2014 at 7:11 am

#1719205

Thanks for the question, Gerald.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 5

Ed Wagner (6/5/2014)
It's nice to have a simple question every once in a while. Thanks.
This is the type of question that makes me REALLY think about the data type and how it works under the hood. Once you explore how it really works, it can help when you're writing code.

+1 Thanks for the question

Everything is awesome!

Hany Helmy SSChampion Points: 13921 More actions · Answer 6

Clive Strong (6/5/2014)
I did pick the right option. However, all 3 could be the easiest, depending on your coding style.
Alternatively, you don't need the CAST.
SET @boolean = @TrueFalse
works just fine, too.

That`s what I call easy 😀

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant