Handle " character in query statement string in C#
Posted on 2011-02-15
I have a problem to compose a query statement in C# with the record starting with " character.
I want to select a record which does not contain character double quote ".
e.g. select name from mytable where name is not null and name not like '"%'
In C#, When I
string sqlstring = " select name from mytable where name is not null and name not like '"%' ";
it looks like '"%' is not right. ???