hi jamie,

i tried your suggestion and purno&rcno has an index but no changes the select statement is too slow to execute,, all i need is a replacement for this select statement.

pls help

thanks,