Yep - I knew the "right" answer, but I entered "An error" just because there was one - in the question itself! Again! Sorry Steve, as much as I respect...

So did I - and got it wrong! That was the start of my downfall....

As usual, I am getting more confused the more I look into things! I use (rightly or wrongly - let's not get into that discussion) integer data as bitfields to...

Perry Whittle (5/17/2016)

---

This is not an integer expression.

The code first checks the binary values for @a and

Please explain why comparing the value 1 with the value 1 fails? The "explanation" talks about trailing zeroes, but the difference in the initialisation values are leading zeroes, which in...

I had...

I don't understand how this can work, even if you do pass 'bsmith' rather than 5 into the check function (can '5' be cast as a sysname, anyway?).

The function returns...

This harks back to a similar post a little while back, and as a result I got this right. However, I still fail to see any logic in a process...

This is yet another one of those things in SQL Server which appear counter-intuitive. To me, at least. If I want to check that any data in that column must...

Maybe soundex() would be a valid approach if it is the pronunciation that matters.

'bok', 'book' and 'booookkk'' all produces a value of B200 in a quick test.

I don't think any of the answers are correct because the question refers to Products, and there is no mention of products in the query, only sales order values. Without...

I am not convinced that this is the right answer to the general problem. It works with that particular data set only because there are no duplicate subjects. We were...

Eric M Russell (8/21/2015)

---

You are standing in an open field west of a white house, with a boarded front door.... Opening the small mailbox reveals a leaflet.

> read leaflet

"ZORK...

Er, all which three books of the four that are in the data .... ?

This is probably a case of me not understanding some terminaology, but what is the difference between what this UDF is doing, and the function referenced in the explanation of...