CREATE FUNCTION Sushi (@numar VARCHAR(76),@div TINYINT)
RETURNS TINYINT
AS
BEGIN
DECLARE @numar1 NUMERIC(38)
DECLARE @numar2 NUMERIC(38)
DECLARE @auxiliar NUMERIC(38)
SET @numar1 = SUBSTRING(@numar,1,LEN(@numar)/2)
SET @numar2 = SUBSTRING(@numar,LEN(@numar)/2+1,76)
SET @auxiliar = '1'+REPLICATE('0',LEN(@numar2))
RETURN (((@numar1%@div)*(@auxiliar%@div))%@div+@numar2%@div)%@div
END
GO
SELECT dbo.Sushi('1010101011131007593840000272449',97)
GO