View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dave k dave k is offline
external usenet poster
 
Posts: 21
Default SQL embedded "IF" statement

Is there a way to embed an if statement into a SQL select? I want to make a
select output field = to one thing if a field is 1 and different if a field
is < 1. I am using Excel to perform all queries. If possible it might look
like this but I don't see if the IF is supported. If not, is there a
workaround?

SELECT F1, F2, IF(F11,F1*3,F1*2) FROM ATABLE

Thanks,
Dave