>What is the best way to optimize searche trough text.
>
>SELECT * FROM mytable WHERE fldstring LIKE '%STR%'
>
>
>Kind regards
>
>
>Jan Dorresteijn
You can't optimize this query.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer