>yeah... I know Peter Samplas too
>
>NOFILTER is a condition used in sql´s select statement, that allow writing in the cursor generated by select..
>
Actually, not quite accurate. If you have a SQL SELECT that just pulls data from one table, a filter will be placed on the table rather than creating a cursor. Using NOFILTER forces the cursor to be created.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer