尝试：

SELECT * FROM MyTable WHERE ColumnName LIKE '%myCompareString%'

您可能希望代码将TextBox.Text设置为参数SqlCommand对象，但这取决于您要使用的语言。

You will probably want code to set the TextBox.Text as a parameter to the SqlCommand object, but that depends on which language you want to use.