SELECT specid,poundcodes,POS(ucase('SMEAR') IN ucase(poundcodes))
FROM specs S
WHERE s.specid='IRBD56404384' AND state in (4)
GROUP BY specid;


is the above query valid?

I know the word 'SMEAR' is in the memo field poundcodes, POS is always = 0


Thanks,
silven

Never mind.... I just realized my copy and paste included the group by.

Thanks

silven wrote:

SELECT specid,poundcodes,POS(ucase('SMEAR') IN ucase(poundcodes))
FROM specs S
WHERE s.specid='IRBD56404384' AND state in (4)
GROUP BY specid;


is the above query valid?

I know the word 'SMEAR' is in the memo field poundcodes, POS is always = 0


Thanks,
silven