>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)
Mark McCasland
Midlothian, TX USA