select 'A/' +right(cast(year(GETDATE()) as CHAR(4)), 2)+'/'+ + cast(max(right((CaseNo), 2) )+1 as varchar(50))as caseno from tbl_RecordRequisition
size
Right
select 'A/' +right(cast(year(GETDATE()) as CHAR(4)), 2)+'/'+ cast(max(right((@CaseNo), 3 ) )+1 as varchar(50))as caseno
cast(max(right((CaseNo), 3) )+1 as varchar(50))
Declare @CaseNo As int Set @CaseNo= 100select 'A/' +right(cast(year(GETDATE()) as CHAR(4)), 2)+'/'+ + cast(max(right((@CaseNo), 3) )+1 as varchar(50))as caseno
cast(max(right((CaseNo), 2) )+1 as varchar(50))as caseno
cast(max(right((CaseNo), 3) )+1 as varchar(50))as caseno
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)