>What is the best way to do this type of substring search now that the data is in SQL tables?
>
>

>SELECT Field1 FROM Table1 WHERE 'Microsoft' $ Field2
>

SELECT Field1 FROM Table1 WHERE field2 like '%Microsoft%'

PS: Also check fulltext enabling your tables for such queries.
Cetin