Hi Trey,
>>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, ....
SELECT CONVERT(smallint, Get_Age()) ...
That way I could still have NULL as the result. i.e. an Integer NULL.
I may end up using nvl() to convert that NULL to -999 or something...
Bill Armbrecht
VFP MCP