Yep, I used... nullif(@DateIn,'') and it worked just fine. I suspected that T-SQL could do it cleanly, but my skills at T-SQL null-handling are very weak.
Thanks Niall, and Teddy On 1/23/07, Niall O'Doherty <[EMAIL PROTECTED]> wrote: > Just thinking out of the box here, and not sure if this is exactly what > you're after but wouldn't you be better letting SQL decide what to insert. > > By using the NULLIF() SQL Function you can still pass your date as 01/01/00 > if no date is specified and use the NULLIF() function to evaluate what to > insert...either the date or NULL. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
