vivek.yadav (4/7/2010)
vk-kirov,You are worng...
declare @bit bit
set @bit='00000'
select @bit
will always return 0 as o/p.
Please if you can check again.
That's what he said. Your post claimed it returned 1. Read back and check. 😛
He did say it was probably just a typo.
Oh, and you spelt 'wrong' wrong - another typo? 😉 😛
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi