hi,
i am trying to run this query on sql 2000 server:
SELECT LAST(birthdate) AS LastBirthDate
FROM MediCarePatients
ORDER BY age
and server returned this msg to me:
'LAST' is not a recognized function name.
i am kinda new to sql 2000 server and is the LAST function removed??
if it is, is there an alternative way to do it?
i am trying to run this query on sql 2000 server:
SELECT LAST(birthdate) AS LastBirthDate
FROM MediCarePatients
ORDER BY age
and server returned this msg to me:
'LAST' is not a recognized function name.
i am kinda new to sql 2000 server and is the LAST function removed??
if it is, is there an alternative way to do it?