I'm working with a stored procedure in SQL 2000 and I am passing 2 parameters into the function.

If either of the parameters has a space or / or % or any other character that might separate a word (text) I get an error.

@CompanyTitle = Auto Body Shop"

Error Message: Line 1: Incorrect syntax near 'Body'.

Any ideas as to how to fix this problem?