you weren't too specific but try something like: select ... where ColA is null
</rob> -----Original Message----- From: Graham Pearson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:41 PM To: CF-Talk Subject: Null Values in MSSQL Group: This is the first time that I have to test for a NULL Value in MSSQL to retrieve a record set. However, at my present knowledge level, I am unable to retrieve this record set. Anyone have pointers on how I can do this? ---------------------------------------------------------------------------- --------------- Graham Pearson, System Administrator / Certified Webmaster Northern Indiana Educational Services Center Http://support.niesc.k12.in.us Email: [EMAIL PROTECTED] Voice (574) 254-0444 Ext 108 / (800) 326-5642 Fax: (574) 254-0148 ---------------------------------------------------------------------------- ---------------- ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists