Converting cfquery to TSQL stored procedure

[roofusthedoofus]

Does anyone know how to convert this cfquery to TSQL code.

The goal is to have MS SQL 2000 run this query in a stored procedure for the
sake of speed, rather than have Cold Fusion process it.

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

I'm having a difficult time creating the IF condition in TSQL in the WHERE
statement to only process the variable #form.firstname# only if it is not null.

[byron1021]

create proc myproc
@name varchar(100)
as

IF @name is not null
select * from profiles where 0=0 and firstname = @name
else
select * from profiles

RETURN 0

Should take care of it