If you're running against Oracle, you can use Oracle's INSTR function: begin-program let $fruit = 'banana' begin-select instr($fruit,'an',1,2) &where show &where from dual end-select end-program _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users