Instead of Stored procedure, you can simply do this CASE WHEN col is NULL THEN 'YOURINDICATORFORNULL' ELSE col END AS col
HTH On 10/8/07, Richard White <[EMAIL PROTECTED]> wrote: > > perfect, thanks very much charlie :) > > in relation to the issue of null values being different to empty strings > in the database, am i right by saying the only way to get round this would > be to create a stored procedure that ran sql code to test for a null value > or empty string then pass back a result to cf telling it whether it is null > or an empty string? > > thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290576 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
