You could do a locate for '617' $ PhoneNo, I'm not sure how good that would be preformance wise since the $ operator is not Rushmore optimizable, it would be much better if you broke apart the number or even better (simpler?) had an index on each of the parts, like substr(PhoneNo,3,3) for the area code, and so on.
>Hi all,
>
>I am trying to a search on parts of a phone number field
>The US phone numbers are formatted as follows 1-617-454-5842
>I have an index on the entire field and therefore can only look
>up the entire field.
>I want to be able to pull up all the 617 or even look up maybe the 5842
>endings or ideally any/all parts of the number.
>How do I go about doing this.
>
>Thanks in advance
>Carmel
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only