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