I need in finding the best match.
I have two tables one is zones table with
Zonename and prefixes eg
another table where in i have a number 00447766055088
i just want to find the zone name from the zones table.I need a BEST match searching TSQL
Thanks in Advance