Posted by Andrew Chalk on 01/12/06 21:41

where columnName like '%777%'



Thank you Andrew

"Andrew Chalk" <achalk@magnacartasoftware.com> wrote in message
news:w5yxf.624$PL5.111@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.
>

[Back to original message]