By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,872 Members | 2,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,872 IT Pros & Developers. It's quick & easy.

Searching for a partial match in a varchar field

P: n/a
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.
Jan 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi I dont 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.

Jan 12 '06 #2

P: n/a
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.

Jan 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.