How about using the TRIM function? <cfif LEN(TRIM(fieldname)) LTE 0>
-----Original Message----- From: cc [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 8:52 PM To: CF-Talk Subject: testing for nulls we are using a <cfif len(fieldname) LTE 0> to test for null values but it's proving unreliable. Any ingenious ideas or thought on this dilemma? Thank you Chris Christianson ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

