Trim Phone Number and wildcard search
So I am trying to trim and wildcard search a phone number, so that it will find it by looking at the numbers in that specific order.
For example, whether someone enters (123) 456 7890, 123-456-7890, (123)-456-7890 or 123 456 7890, I want to be able to first:
a) Eliminate all special characters ), (, -, etc
b) Trim(All) (Which I already know how to do)
To make the result: 1234567890
c) Then I want to insert * before and after every digit so it results in this: *1*2*3*4*5*6*7*8*9*0
I've tested the result, and this searches for the correct number regardless of how it was input in the system.
Can anyone help me with steps a) and c)?