select top 1 ([Casetype] +'/'+ CaseNo +','+ YEAR(GETDATE()) )as CaseNo from tbl_RecordRequisition where Casetype='FA' order by id desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)