Home Where Clause Case Statement
Reply: 0

Where Clause Case Statement

user332
1#
user332 Published in July 17, 2018, 7:25 pm

How can I have a where clause be based on a variable:

If I have a variable @PrintNum and it has a number I want a different where clause, but it not it is different. See below: Is this possible?

Where PrintNum = @PrintNum
Else
Where InvNum = @InvNum, 

etc....

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.386651 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO