I have a database that I am trying to query from within T-SQL.<BR>For instance I have a table with a field called Field1. <BR>Its values are:<BR> field1<BR> row 1 Sayro Fund "F" LP<BR> row 2 Fidelity Fund "G" LP<BR><BR><BR><BR>How would I run a query in TSQL which contains a substring with "F". The double quotes are throwing me off.<BR>I think I can do this in VB, but what is the syntax for this <BR>in T-SQL.<BR><BR>