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?