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