any sql code to search database tables ?

[mentor]

I want to add a searching function in my website, to search product stored in a table in sqlserver 2005. The keyword may contain some special character like --,(,), etc. The codes I compiled won't work well.

Is there any open source code with such functionality? code for mysql is also welcome :) thanks