>Does anyone know how I can implement IIF statements in an SQL. I am running a SQL select statement that looks for the patient id but the problem arises when the patient has two different visit dates to the doctor. but I only need the latest date.
Sure...
SELECT patname, iif(pattype = "A","ACUTE ","CHRONIC") as ptype ;
FROM patient
INTO CURSOR cPats