Posted by Jens on 09/13/05 16:49

USE NORTWIND
GO

IF EXISTS (SELECT * from Orders where orderID = 10235)
SELECT * from Orders where orderID = 10235
ELSE
SELECT 0


HTH, Jens Suessmeyer.

• Next in forum: Re: Monitoring Software
• Prev in forum: How to override zero rows returned
• Thread view: Re: How to override zero rows returned

[Reply to this message]