>This particular SQL Query is generated out of FoxFire! So far I haven't come up with a better way. Performance hasn't been an issue for this UDF. I do avoid them where possible. Haven't come up with a good iif() for Age, yet. I've watched the Age threads recently, BTW.
>
>Too bad VFP doesn't have the Convert() function like SQLServer.
Where would you use the Convert() if you could? In the SELECT statement?
If so, you could still return .NULL. from Get_Age() but use Nadya's idea of 1000 in the SELECT by using the NVL() function. e.g.
SELECT NVL(Get_Age(), 1000) As age, ....
Insanity: Doing the same thing over and over and expecting different results.