>Does anyone know how to code a SQL statement that will return a resultset containing only the locked records?
>
>I know the SYS(2011) function works on a record by record basis, but it doesn't return any records when I use it in a SQL statement.
>
>TIA
select * from mydata where isrlocked()
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown