To begin with, if TIEINS is number, then your WHERE condition should be: WHERE TIEINS = 1 not WHERE TIEINS = '1' -- This is wrong S --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.265 / Virus Database: 137 - Release Date: 18-Jul-01