SQL Server Function returns an error.

Question

I created one function to check whether the id exists or not. If it is exists then it returns 1 otherwise it returns 0 but i got an error like this RETURN statements in scalar valued functions must include an argument. My function is create function [dbo].[CheckStudentId](@ID varchar(10)) returns varchar as begin return if exists (select id from Tablename where id=@ID) print 1 else print 0 end Thanks in advance

Manesh Golekar · Answer

Use below code create function [dbo].[CheckStudentId](@ID varchar(10)) returns int as begin declare @flag int; if exists (select id from Tablename where id=@ID) set @flag = 1; else set @flag = 0; return(@flag); end