For a bit field, is using
WHERE mybit = 0x0
WHERE mybit = 0
I am being told to use 0x0 but am not yet convinced.
I suspect the person who told you that assumed it would avoid an implicit conversion in the execution plan. So the way to tell is to try both and compare the plans.
I've just done that with a very simple test, and the results were the other way around.
Using 0x0 resulted in an implicit conversion to bit, whereas using 0 did not.
The conversion is performed just once against a constant, so has zero impact on cost. Both queries had identical cost, even down to 7th decimal place.
Check Your SQL Servers Quickly and Easilywww.sqlcopilot.com