If using varchar trim wont be necessary (usually).
<cfif myvariable is "">
However as I have said if your table contains empty strings ("") as well as
NULL values you may wish to differenciate between the answers, in which case
you can use the ISNULL() SQL function within your select staement so that
NULL values will not just be "" (empty quotes), as an empty string value
would be.
Regards,
Anthony Geoghegan
Lead Developer,
IFTN
www.wow.ie
-----Original Message-----
From: Jacob [mailto:[EMAIL PROTECTED]]
Sent: 27 June 2000 15:12
To: [EMAIL PROTECTED]
Subject: RE: NULL using it in CF
<CFIF myvariable is "" or myvariable is " ">
of <CFIF trim(myvariable) is "">
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
