SQL: IF clause within WHERE clause

Question

Is it possible to use an IF clause within a WHERE clause in MS SQL?Example:WHERE IF IsNumeric(@OrderNumber) = 1 OrderNumber = @OrderNumber ELSE OrderNumber LIKE '%' + @OrderNumber + '%'

Chloe Burgess · Accepted Answer

To use an IF clause within a WHERE clause, you can try using the CASE statement like this: WHERE OrderNumber LIKE CASE WHEN IsNumeric(@OrderNumber) = 1 THEN @OrderNumber ELSE '%' + @OrderNumber END

SQL: IF clause within WHERE clause

About this question

Your answer

1 Answer

More Tableau discussions

Learn & Explore

Popular Tutorials

Tableau Interview Q&A

Latest Tableau Blogs

Want answers to more Tableau questions?

Stay in the loop — it’s free

You’re on the list!