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.
>
Navigation:
[Reply to this message]
|