>If I have a IsNull() syntax in my SQL command, how can I convert that into a SQL command that will work under SQL Server?
In SQL statement it would be
CASE WHEN Field IS NULL then something else end
In T-SQL
IF @Var IS NULL
...
If it's not broken, fix it until it is.
My Blog 
