After a recent switch from MS Access to SQL Server 2000 some simple ASP if statements seem to not work.
In MS Assess I would use this an if statement to determine if a field was null.
<% if objRS("Review") <> "" then %>
Now this doesn't work to evelauate the field in SQL Server 2000 for null. I work with allot of text and it seems redundant for me to put triggers into the databases that will have to be maintained and updated when a text fields is empty or not.
Anyone with experience in this or who knows how to work with if statements, ASP when dealing with SQL Server 2000 would be greatly appreciated.