Showing results for 
Search instead for 
Do you mean 

brackets phone format

Copper Super Contributor
Posts: 128
Country: USA

brackets phone format

i have a mixed data base of phone formats

ie {nnn} nnn-nnnn and nnn nnn nnnn and nnn-nnn-nnnn


note the brackets and spaces and dashes

trying to do a lookup via


"Phone>Starts With>{"

"Phone>Starts With>{nnn}


i want the results only to show phone numbers starting with a bracket

however I am getting numbers without the brackets


some how the lookup is ignoring the bracket

unless my bolean search is wrong any idears


thanks inadvance


server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory