select count(*) VALEXISTS from tablename where fld = 'fldvalue'