Create table ClientInfo ( ClientId int identity(1,1) primary key, ClientCode As ('SAPL-' +Right(substring(OrganizationName, 1,3) +Right('00000' +Convert(varchar, ClientId,0),(5)),3), OrganizationName varchar(100))
'SAPL-' + substring(OrganizationName, 1, 3) + '-' + Right('00000' + Convert(varchar, ClientId, 0), (5))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)