March 11, 2009 at 8:59 pm
Spikemarks (3/11/2009)
I have tweeked the code and have put it inside a cursor which should read the first 3 chars and then change to which ever it should be.Once I have tested etc I will post for other people to use.
Beer in post!
Heh... now why would you mess up some nice set based code with a cursor? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
March 11, 2009 at 9:05 pm
aram_golbaghi (3/11/2009)
hii think gsquare's solution is verywell,
works fine
Yep... right up until you dial a 1 or 3 digit country code instead of +44.
Country codes can be from 1 to 3 digits.
City codes can be from 0 to 4 digits.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply