>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

SQL Server (well, RDMBS's) doesn't have a concept of record number, but if you need to show some kind of numerical ordering based on the order of the data desired, you can do this

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133