Hello, I am creating a table and I would want two particular fields to concatenate to form a 3rd field. Take for instance:Blockquote
class int not null,
studentNo int unique IDENTITY(100000,1) Primary Key,
StudentCode...
Class field will be 3-digits integer.
StudentNo will be automatically generated, starting from 10,000
StudentCode (I want it to contain the class 3-digits for each student and also the studentNo. It will start with the 3-digits of the class. i.e to concatenate the class value and the studentNo value)
I try as much to explain because I want explicit suggestion.
If you are proficient with database (MySql or Microsoft Sql), and you know about this, then kindly help.
Please help with a line or lines of codes.