Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
goligol
Posting Yak Master
128 Posts |
 Posted - 2011-07-20 : 10:14:29
|
| I am trying to find the NULL records. when I type: where V0 = 'NULL' it gives the following error:Msg 8114, Level 16, State 5, Line 2Error converting data type varchar to bigint.when I type the condition as : where V0 = NULLit brings no record while I know there are records where V0=NULL SELECT [O] ,[D] ,[M] ,[C] ,[V0] ,[T0] ,[TM0] FROM [bts].[dev].[xListOfChildrentAlList] where V0 = 'NULL'Thank you |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-07-20 : 10:16:38
|
where column IS NULL
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
goligol
Posting Yak Master
128 Posts |
Posted - 2011-07-20 : 11:36:11
|
| Thank you thank you thank you |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-21 : 01:36:03
|
| NULL is not stored as a value so operators =,>,< etc wont work with it under default conditions. (ANSI NULL setting)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
printing NULL records