Composite column idea needed
Posted on 2009-04-02
I have an identity field that increments , for example, 1234, 1235, 1236.
I have another column that has country code. When I pull up this number, I can concat the country code to the number: UK1234, US1235
So, 2 coulmns: one country code, one number.
**Now, the user enters UK1234 (not pulling up data, but searching for data). I'm thinking about parsing out the string section and just do a search for the number. Then see if that number matches the country-code.
Is there a better way of doing this?