Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
how to avoid single quote in sql queary
Khargesh Rajput
Oct 22 2014 12:07 AM
888
Reply
I have To search data from database.
My query is like as
select * from table where subject like'%'+txtsearch+'%'
and here my textbox has value like ----- teacher's book
this query will give error as syntax error near----- 's
Then how to execute my query,i don't want to remove single quote
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Hi karthik
deploy the project in C# with Crystal R and Sql server