Hi all,

In VFP, I can do a SQL Select like this :
SELECT cnoee,cname,dage(demas.dbirth) FROM demas

If I want to do the same in SQL Server, do I create a User Defined Function for dage in "Enterprise Manager"?

Can someone direct me the correct direction? Some short syntax would be greatly appreciated, :) . If I want to analyse the age of the employee by passing a date, how will I accomplish that? Normally I will pass dage(demas.dbirth,pdanalysis) where pdanalysis is the private variable..

Regards.