You can use a CASE statement in various places in your query, such as in the SELECT ... AND 55 THEN 'Middle-aged' ELSE 'Senior' END AS age_group FROM customers; A SQL IF statement has the ...

To use the CASE statement in SQL for data analysis ... follow this basic syntax: SELECT CASE column_name WHEN value1 THEN result1 WHEN value2 THEN result2 ELSE default_result END AS new_column ...

So, it looks like you can't do a statement like this:<BR><BR>IF <BR> SELECT *<BR> INTO #Temp<BR>ELSE<BR> SELECT *<BR> INTO #Temp<BR> WHERE....<BR><BR>What the best way to work around this?