>Hi all,
> I use vb.net and visual foxpro to database(.dbf). I want to write a function and return row no.
>for example, table and 5 record ( sysid sysname )
> 001 add
> 002 update
> 005 delete
> 009 save
> 100 print
>
>How can i do, Thank you ~~~
>
>
>select ??? from systable where sysname='delete'
>
>I want to return 3 (row 3 in table )


Looks like you need to number first, e.g.

SQL Server:

;with cte as (select *, row_number() over (order by SysID) as Rn from ...)

select * from cte where SysName = 'delete'

For VFP you may try

select * from .. into cursor csrTemp NOFILTER ORDER BY SysID

select *, recno() as Rn from csrTemp where SysName = 'delete'