SQL query using if else

Question

My SQL code looks like this:

SELECT 
    Scores.PupilId, Scores.BoysName, Scores.FormGroup,
    IF (Scores.FormGroup = "10SB", "Great", "ok")
FROM 
    Scores

I get this message

no such function: if: SELECT Scores.PupilId, Scores.BoysName, Scores.FormGroup,
if(Scores.FormGroup="10SB","Great","ok")
FROM Scores

This is flat file database

Can anyone please help me understand why I am getting a message?

Possible duplicate of [How do I perform an IF...THEN in an SQL SELECT?](https://stackoverflow.com/questions/63447/how-do-i-perform-an-if-then-in-an-sql-select) — Procrastinating Programmer, Jul 11 '18 at 20:01

score 2 · Answer 1 · answered Jul 11 '18 at 19:53

2

The correct ANSI-standard conditional expression in SQL is the case expression:

SELECT Scores.PupilId, Scores.BoysName, Scores.FormGroup,  
       (CASE WHEN Scores.FormGroup = '10SB' THEN 'Great' ELSE 'ok' END)
FROM Scores ;

answered Jul 11 '18 at 19:53

Gordon Linoff

1

Yes. MS SQL 2012 added an `IIF()` conditional function, but I believe it essentially evaluates out to a `CASE` statement. – Shawn Jul 11 '18 at 20:18

1 Answers1