select NULL values with TSQL

Post Reply
michel.weber
Posts: 256
Joined: Sat Oct 08, 2005 12:40 pm

select NULL values with TSQL

Post by michel.weber »

Hi i try to find null values in a table, but someho i can't figure the SQL syntax. Standard SQL does not seem to work.

SQL 1>select count(*) from html where U_Publisher IS NULL;
select count(*) from html where U_Publisher IS NULL;
000 Strange value in p->rt: 0 in the function ispredvalid
000 Strange value in p->rt: 0 in the function ispredvalid
000 SQL failed
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

select NULL values with TSQL

Post by mark »

NULLs aren't supported. Try
... where U_Publisher=''
michel.weber
Posts: 256
Joined: Sat Oct 08, 2005 12:40 pm

select NULL values with TSQL

Post by michel.weber »

That works with fields of type TEXT (varchar) but not for type SET (varstrlst).
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

select NULL values with TSQL

Post by mark »

... where U_Publisher=convert('','strlst')
Post Reply