>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 numgrade, get_alphagrade(numgrade) AS alphagrade ;
FROM my_marks ;
INTO CURSOR TEMP

and have function like this in your procedure file.


FUNCTION get_alphagrade
LPARAMETER tnNumGrade
lcReturn = ""
DO CASE
CASE BETWEEN(tnNumGrade, 70,79)
lcReturn = "C"
CASE BETWEEN(tnNumGrade, 80,89)
lcReturn = "B"
CASE BETWEEN(tnNumGrade, 90,100)
lcReturn = "A"
ENDCASE
RETURN lcreturn
ENDFUNC

RETURN

In many cases it may be just enough to have IIF in your select statement like:
SELECT field1, IIF(field2 = 1, "YES","NO") AS myOtherfield FROM...