>Hey all,
>I am trying to do a select, similar to what I do in VFP.
>
>Select recno() as Record,* from myTable
>
>Can you tell me the syntax for this or is this even possible

There are not 'record numbers' in SQL.

BOb