syntax error in function SP

Hi guys

I have three errors in below code:

Code:

CREATE FUNCTION delUserGrp
(@name nvarchar(15))
RETURNS INT
AS
BEGIN

SELECT * FROM [dbo].[user]
WHERE [user-grp-fk] IN (SELECT PK FROM [dbo].[user-grp] WHERE @name =name)

IF @@ROWCOUNT=0
    BEGIN
        DELETE FROM [dbo].[user-grp] WHERE @name=name
        RETURN (1)
    END
ELSE
    BEGIN
        RETURN (0)
    END
END

error: msg444, 443,455
please help me to solve the syntax errors

Code:

CREATE FUNCTION delUserGrp (@name nvarchar(15))
RETURNS INT
AS
BEGIN
    DECLARE @RETVAL INT

    IF NOT EXISTS (SELECT    *
        FROM    [dbo].[user]
        WHERE    [user-grp-fk] IN (
            SELECT PK FROM [dbo].[user-grp] WHERE name = @name
        )
    )
    BEGIN
        DELETE FROM [dbo].[user-grp] WHERE @name=name
        SET @RETVAL = 1
    END
    ELSE
    BEGIN
        SET @RETVAL = 0
    END
    RETURN @RETVAL
END

Excellent!! Thank you Sandeep
but unfortunately I still have msg443 error on Delete line.
what should i do?!

Thank you

your code executed correctly, but I thought procedure cannot return output value!!
I have some question about your codes:
1- it's not so much important to use "return" at the end of procedure?!
2- when we can use function?

thank you

OMG!!! I am sorry for the silly answer. While posting answer, I never realized, delete statement is not allowed in scalar functions. As suggested by Shehap, you need to create stored procedure

Code:

CREATE procedure delUserGrp_SP @name nvarchar(15)
AS
BEGIN
    IF NOT EXISTS(
        SELECT    1 FROM [dbo].[user]
        WHERE    [user-grp-fk] IN (
            SELECT PK FROM [dbo].[user-grp] WHERE name = @name
        )
    )
    BEGIN
        DELETE FROM [dbo].[user-grp] WHERE name = @name
        SELECT 1
    END
    ELSE
    BEGIN
        SELECT 0
    END
END

Great! both of the codes are executed correctely. but whitch one is better?! select or return?