Error in executing a SQL stored procedure

[vivsriaus]

I get this error:
Line 1: Incorrect syntax near '.'

when executing my stored procedure:
ALTER PROCEDURE Test

(
@Func VarChar(100)
)

AS
DECLARE @SQL VarChar(100)

SET @SQL = 'SELECT DISTINCT dbo.ResultSummary.TestName FROM dbo.ResultSummary, dbo.SuiteNameHierarchy' /*WHERE dbo.SuiteNameHierarchy.[Function] LIKE @Func'*/

IF @Func IS NOT NULL
SET @SQL = @SQL + 'WHERE dbo.SuiteNameHierarchy.[Function] LIKE @Func'

EXEC(@SQL)
RETURN

Any help?

[jhardman]

What language is this? The ASP forum is for classic ASP and VBScript questions. Let me know, and I will move your post where it belongs.

Jared

[vivsriaus]

This is a SQL stored procedure for my ASP project. It is related to ASP, isnt it?

[jhardman]

This is a SQL stored procedure for my ASP project. It is related to ASP, isnt it?

Oh, I see. I just assumed since the code you posted wasn't ASP and ASP wasn't mentioned in the post that you had stumbled into the wrong forum. I don't like using stored procedures since I'm better with ASP than I am with SQL, but how about posting your procedure call?

Jared

[vivsriaus]

Never mind. I know where the error is. @SQL is declared as Varchar(100) and my query had more than 100 characters! :-)