StringBuilder ' escape sequence

[StyleGuide]

Hi there, Can anyone suggest the best way, or point me in the direction of, escaping or qualifying an ' (apostrophe) character within a StringBuilder? Unsurprisingly, I get a 'Missing operand after' error with the following:

sb = "LastName = 'O'Brien'"

Thanks Jon

[Bekjong]

StringBuilder sb = new StringBuilder(@"LastName = 'O'Brien'");

Standards are great! Everybody should have one!

[StyleGuide]

Thanks for this Bekjong, Sorry - I forgot to say I am getting the error on this line:

namesBindingSource.Filter = sb.ToString();

Thanks Jon

[dan sh]

Following code gives me no error :confused: BindingSource o = new BindingSource(); StringBuilder s = new StringBuilder("LastName = 'O'Brien'", 50); o.Filter = s.ToString(); Am I missing something?

Avoid Google. Use Blackle[^]

[Vikram A Punathambekar]

In SQL, you have to prefix single quotes with single quotes. yourQuery = "SELECT * FROM Grades WHERE StudentName = 'Scarlett O ''Hara'"

Cheers, Vikram.

---

The hands that help are holier than the lips that pray.

[StyleGuide]

Thanks Vikram, d@nish, Thanks for the tip Vikram. d@anish - Yes you're right, however I get the error when applied to my namesBindingSource Thanks Jon