Community
Showing results for 
Search instead for 
Do you mean 
Reply

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
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide