>I am trying to pull only the record with the highest ticket number from my SQL server back end using a foxpro remote view. The ticket number is an integer field and generated automatically by the Sql server using identity, incrementing by one each time. Does anyone have an idea?

Maybe:

SELECT TOP 1 ...