SQL: Using Case to select a field?
Based on if one field in the database is equal to something i want to select the value of anohter field. I was thinking that i could use CASE THEN but i can't get it to return the value of a field.

Here is what i have tried so far:

    SELECT LastName, CASE FirstName WHEN 'Ian' THEN JobNo END
  FROM Employees

JobNo is the name of the field which i want to get the value from.
SQL: Using Case to select a field?
===

Based on if one field in the database is equal to something i want to select the value of anohter field. I was thinking that i could use CASE THEN but i can't get it to return the value of a field.

Here is what i have tried so far:

    SELECT LastName, CASE FirstName WHEN 'Ian' THEN JobNo END
  FROM Employees

JobNo is the name of the field which i want to get the value from.