Reply to Searching for a partial match in a varchar field
Posted by Andrew Chalk on 01/12/06 21:28
I have a customer who wants to SELECT records based on a partial match in a
text field. For example, in a list of telephone numbers they want to search
for all records that contain the digits '777' in any part of the string. How
do I formulate such a query?