sql server - SQL: if clause in where clause

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 + '%'

Source

This question and all comments follow the "Attribution Required."

All Answers

You must be logged in to post a answer.