Depends on what you want. If you are wanting all records where the value is not NULL
Just do select whatever from table where whatever IS NOT NULL "Success is a journey, not a destination!!" Doug Brown ----- Original Message ----- From: "Graham Pearson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 10:40 AM 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 > ------------------------------------------------------------------------------ -------------- > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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