Hi there,
Probably a really simply task that I cant figure out - blonde moment perhaps?
I have a customer ID as the primary key, it is to be constructed from 2 letters and 2 numbers.
For example, Joe Blogs would appear as BL01
Is it possible to create an ID from reading the first 2 letters of the last name and adding 2 digits to the end?
How would i go about this?
Probably a really simply task that I cant figure out - blonde moment perhaps?
I have a customer ID as the primary key, it is to be constructed from 2 letters and 2 numbers.
For example, Joe Blogs would appear as BL01
Is it possible to create an ID from reading the first 2 letters of the last name and adding 2 digits to the end?
How would i go about this?