SQL Wildcard Search Example

I'm forever forgetting how to do these so am posting an example here.


"SELECT * FROM myTable WHERE myTable.FieldName LIKE '%' + '" & Trim(myString) & "' + '%'"