Hi,

I got a problem on searching a keyword with '&'.

I run this query and I got all records with '&'.
select * from freetexttable(table1, *, 'AT&T');

I run this and I got records with AT&T.
select * from table1 where fieldname1 like '%AT&T%'

Since 'AT' and 'T' are considered noise words, how can I search for
'AT&T' as a whole word?

Thanks in advance.
Baldwin