>>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?
>
>Try something like:
>
>select * from mytable where ticket_number in (select max(ticket_number) from mytable)

... or something like:

select top 1 * from mytable order by ticket_number desc

Note: the top option works only in SQL 7.