Fields :: idno name advance months ------------------------------------ 001 Pet 400 2 002 jane 5 003 hens 300 4 004 pal 340 007 sam
idno name advance months ------------------------------------ 002 jane 5 004 pal 340 007 sam
SELECT * FROM Trial WHERE advance IS NULL OR months IS NULL
SELECT * FROM Trial WHERE ISNULL(advance,'0')<>'0' OR ISNULL(months,'0')<>'0'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)