SP and UNICODE

[invitro]

I have a stored procedure in my msSQL 2000 DBase... but every time it takes a string that has a character such as ., !, %, $, @, or anything like that it spits me out this error.

Line 1: Incorrect syntax near '.'.

CREATE PROCEDURE sp_getTableWhere

	
	@vTable nvarchar(50),
	@vcharValue1 nvarchar(50),
	@vcharValue2 nvarchar(50)
AS
	
	--Declaring variable to store our query
	Declare @sql nvarchar(500)
	

	SET @sql = 'SELECT * FROM ' + @vTable + '  WHERE ' + @vcharValue1 + ' = ' + '''' + @vcharValue2 + ''''


	EXEC(@sql)

	return
GO

I initialy thought it was my nvarchar, since I had it set to varchar before but it looks like it has nothing to do with that. I'm extremly confused as to why this is happening. I searched everywhere and found no answer.

If you could give me a hand, a link, an idea, anything... im depsperate. PLEASE!!!!!!!!

-Alek

[invitro]

So it kinda works... man, this is messed up.

When i do a query for the email address it does not find it.

SELECT * FROM tblUser WHERE (charEmail = '[email protected]')

This wont work with the SP search function i wrote either... why, oh whyyyyyyyyyyyyyyyyyyyyy