select ... from mytable where phone like '%617%'

>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