I need to create an ID from two fields when they are entered into the db for the first time. I thought Uniqueidentifer would do this, but it looks like uniqueidentifier is random and i have no control of the process.
My user will enter 4 letters into a column called INIT and 4 numbers into a column called NUMB. What I would like to do is create an id by combining those fields.
How can I do this?
View Complete Post