When I execute the below query im getting the following error
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near ')'.
Any one please give a solution to solve this.

In the below query dbo.FNSplitStri ng is a user defined funcion to split the values in the string, since here project code parameter is in varchar but in the table it is integer datatype.

Code:
DECLARE @prjcode VARCHAR(1000)
SET
...