Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is Last() function removed from sql 2000?

Status
Not open for further replies.

sqlgrade1

Programmer
May 18, 2002
5
CA
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?
 
Depending on what you are doing, this thread may be of interest to you.:

thread183-275491
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top