I am trying to generate a unique column CardControlNumber. I want to have some string or suffix attached to a auto number. For example my CardControl Number should look some thing like this:
If i cannot suffix with string, i can also suffix my suto number with IDs like
How can i do this in SQL??