April 23, 2005 at 8:40 am
Our client would like a two character country code returned from our data but we are storing country codes as three characters. We do have a 'country' table and I was thinking that I might have to add a new column to the table for the two character format and then reference the data in that column. I also thought that I might be able to do a substring on the existing values but their data does not correlate well with our data. What would be the best approach for tackling this task? Any help would be greatly appreciated.
April 23, 2005 at 12:29 pm
I would do as you said... add the extra column with the 2 character country code to the Country table .
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2005 at 12:37 am
Most safest methos would be adding a columna s you said. Substring method does not gurant that it will not return same code for two differetn countries.
My Blog:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply