I a used to using ASP to connect to an Access db, but am having to upgrade to MSSQL due to the capacity of the data. In chaning the ASP scripts I am finding bits and pieces of lines that are not compatible with MSSQL. The one big one is anything in a Query that says isNull().
What is the equivilant of isNull for MSSQL? Instead of saying WHERE isNULL(custID) should I just say WHERE custID='' ? Does it mean the same thing or am I missing a function that I need to be using here?