NULL value

[Guest]

how can write this syntext. I want to check the null value from db. I am using sqlserver. I have to put double quotes or single coutes. thanks

<cfquery name="ss" datasource="ddd">
select type from xdd
</cfquery>

<cfif #rp.type# eq "" or #rp.type# eq NULL>
<cfset type='dd'>
</cfif>

[paross1]

Is this what you are asking?

SELECT yourfield
FROM yourtable
WHERE somefield IS NULL

EDIT: Sorry, disregard my reply as I misread your original post.

Phil

[BKBK]

<cfif Len(Trim(ss.type)) eq 0>
<cfset type='dd'>
</cfif>

[Guest]

I want to check if value is null from my query

for example like this NULL or " " in my if statement

cfif #rp.type# eq "" or #rp.type# eq NULL>
<cfset type='dd'>
</cfif>

[BKBK]

If you insist, assuming the unlikely event your query returns the null string, do

<cfif Len(Trim(ss.type)) eq 0 OR ss.type is "null">
<cfset type='dd'>
</cfif>

(Incidentally, the name of your query is ss not rp)