quote:

---

CREATE FUNCTION [dbo].[GetId] (@Today Datetime)
RETURNS nchar(8)
with execute as caller
AS
BEGIN
declare @seqno nchar(8);
declare @No nchar(4);
select @seqno = year(@today);
select @No=cast(cast(right(LastId, 4)as int)+1 as nchar(4)) from Idmaster;
select @No=left(replicate('0', 4), 4-len(@No));
RETURN (@seqno + @No);
END

---

quote:

---

SELECT DBO.GETID(GETDATE())

---

CREATE FUNCTION [dbo].[GetId] (@Today Datetime)
RETURNS char(20)
with execute as caller
AS
BEGIN
declare @seqno char(4);
declare @seqno2 char(20);
declare @No char(4);
declare @no2 char(4)
select @seqno = year(@today);
--select @No=cast(cast(right(LastId, 4)as int)+1 as nchar(4)) from Idmaster;
select @no = '2' --replaced your query from Idmaster table
select @No2= cast(left(replicate('0', 4), 4-len(@No)) as char(4))
select @seqno2 = @seqno + ltrim(rtrim(@no2)) + @no
RETURN @seqno2
END


SELECT DBO.GETID(GETDATE())