Using vfp6 and modifing an old program. I would like to use an IIF to determine the name of the returned field in the select statement. Is this possible?
example:
select first, last, dob as iif(year(dob)<1980,"Young","Old") from member
Of course, in this example, there would be four columns in the query - first, last, young, old
i can provide more details on why i want to do this if needed.
thanks for any input!
-xeno
example:
select first, last, dob as iif(year(dob)<1980,"Young","Old") from member
Of course, in this example, there would be four columns in the query - first, last, young, old
i can provide more details on why i want to do this if needed.
thanks for any input!
-xeno