I have a large taqble of telephone calls which consists of phone number dialled|time of day|Duration. I have a separate table which consists of Country code|Country Text|Rate per minute. I would like to create a join between these two tables so I can do some what if analysis with different rate structures. However the country code portion of the phone numbers range from 1 to 3 Characters. For example, USA is 1 and Ireland is 353, therefore a US number might be 0012125551212 while Ireland would be 003531232323. Is there anyway to create a join on variable lengths of characters or anyway to easily extract the country code?
Thanks in advance!
Thanks in advance!