How u convert this cfquery to TSQL?

[roofusthedoofus]

Does anyone know how to convert this cfquery to TSQL?

<cfquery name="test" datasource="abcinc">
select *
from profiles
where 0=0
<cfif isdefined('form.firstname') and form.firstname neq ''>and
firstname='form.firstname'</cfif>
</cfquery>

I'm having a tuff time creating the condition in the WHERE part to check if
the variable form.firstname exists first, and then to make sure its not null.
I'm trying to build a search form and then have the search criteria queried in
a MS SQL Server stored procedure directly for the sake of speed.

Appreciate any help:)

Roofus.

[kim il sung]

<cfif isdefined('form.firstname') and Trim(form.firstname) neq ''>
<cfquery name="test" datasource="abcinc">
select *
from profiles
where firstname='#Trim(form.firstname)#'
</cfquery>
</cfif>

cheers
kim

[OldCFer]

For a simple query a stored procedure won't give you any performance benefit.