Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I use the case statement ?
Message
From
20/12/2001 11:24:24
Michael Levy
Cincinnati, Ohio, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Can I use the case statement ?
Miscellaneous
Thread ID:
00596736
Message ID:
00596813
Views:
20
Try something like this:
SELECT
 *
FROM
 coAudit
WHERE
 (@tiUserid = 0 OR tiUserid = userid)
 AND (@tcAction = 'ALL' OR actiontype = @tcAction)
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform