Searching for a partial match in a varchar field

[Andrew Chalk]

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?

Many thanks.

[Jens]

Hi I donßt know if you mean that the column if of the type text or its
just a text column. Anyway, if you use wildcards you can use this
query:

Select *

From SomeTable

Where SomeColumn LIKE '%777%'

HTH, jens Suessmeyer.

[Andrew Chalk]

where columnName like '%777%'

Thank you Andrew

"Andrew Chalk" <ac****@magnacartasoftware.com> wrote in message
news:w5***************@newssvr11.news.prodigy.com. ..

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?

Many thanks.