>HI, all
> I use sqlserver 2005, the field value is NULL, how can i use sql statement where to select it?
>i already use isnull but i can't select it ,Thank you ...
>
>

>select * from funclib where formname=isnull(formname,'NULL')
>
>

Alex,
do you want to select all records where

formname = @somevariable or NULL

?
Then I would try this.

SELECT * from funclib where formname IS NULL OR formname=@somevariable