AFAIK, there is no such beast as a RecNo in SQL Server. Why do you need a RecNo? Can a PK be used instead?

>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