Its in fact easy to handle special characters like "%" in query, with just a bit of research one can found solution for this.
Today when i checked events for my server i found that one error message and that was because a user searched for " l'atelier " on my site, with this word the query will become like:
Select * from Category where MDelete =0 And CategoryName Like '%l'atelier%'
where as for a simple word like e.g "lipstick" the query works fine and will be:
Select * from Category where MDelete =0 And CategoryName Like '%lipstick%'
Any body please tell me how can i handle this??