>Using a SQL statement, I like to be able to to look at a field and if it's in a certain range, have it give a code in another field. Lets say grades for example, range 90 to 100 'A', 80-89 'B', 70-79 'C'. So if numgrade = 89, i like to have alphagrade = 'B'
>
>TIA,
>
>Jim

SELECT ;
    IIF(BETWEEN(nGrade, 90, 100), "A", ;
    IIF(BETWEEN(nGrade, 80, 89), "B", ;
    IIF(BETWEEN(nGrade, 70, 79, "C", "D")))) AS cLetterGrade, ;
    ....

If you are SELECTing against an SQL database you will need:

cMySQL = [SELECT CASE ] + ;
    [WHEN nGrade BETWEEN 90 AND 100 THEN "A" ] + ;
    [WHEN nGrade BETWEEN 80 AND 89 THEN "B" ] + ;
    [WHEN nGrade BETWEEN 70 AND 79 THEN "C" ] + ;
    [ELSE "D" END AS cLetterGrade ] + ;
    [...]