Thunderstone Support Forums

Posted: **Mon Apr 12, 2010 12:50 pm**

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

Posted: **Mon Apr 12, 2010 2:08 pm**

NULLs aren't supported. Try
... where U_Publisher=''

Posted: **Tue Apr 13, 2010 4:21 am**

That works with fields of type TEXT (varchar) but not for type SET (varstrlst).

Posted: **Tue Apr 13, 2010 10:45 am**

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

Thunderstone Support Forums

select NULL values with TSQL

select NULL values with TSQL

select NULL values with TSQL

select NULL values with TSQL

select NULL values with TSQL