IF EXISTS ( Select Foo FROM Bar Where Whatever = 1) -- result set returned BEGIN -- BEGIN is equiv to java { end is like java }
END ELSE -- no results returned BEGIN END -- jon mailto:[EMAIL PROTECTED] Thursday, August 8, 2002, 8:38:05 PM, you wrote: NH> I want to do something in TSQL if results are returned. I forgot the NH> syntax. I think its @@selected but I can't be sure could someone point me NH> in the right direction. NH> Thanks, NH> Neil NH> ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists