convert mysql query to sql server query

Question

I want to convert below mysql query to sql query.I want to use If condition in sql server

SELECT
foodName,
IF( foodPrice>2000, 'Expensive', 'Cheap') as fpDesc,
discountPercent
FROM restaurant.foods;

u could use of IIF() if u r working with sql-server 2012 or + else case expression — Yogesh Sharma
– Yogesh Sharma, Commented Nov 17, 2017 at 8:28

GuidoG · Accepted Answer · 2017-11-17 09:15:01Z

4

if is MySQL proprietary, as you noticed. The standard way to do this is case

CASE WHEN foodPrice > 2000
     THEN 'Expensive'
     ELSE 'Cheap'
 END

GuidoG

12.3k6 gold badges59 silver badges101 bronze badges

answered Nov 17, 2017 at 8:28

Markus Winand

8,8541 gold badge38 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1