Answers for "sql if clause within where clause"

SQL
0

sql if clause within where clause

WHERE OrderNumber LIKE
  CASE WHEN IsNumeric(@OrderNumber) = 1 THEN 
    @OrderNumber 
  ELSE
    '%' + @OrderNumber
  END
Posted by: Guest on July-28-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language