Hey I have what I think is a simple question. How would i insert an apostrophe into a sql string without getting an error. Thanks in advance

It's kind of ugly, but this is what I do.

char qq = new char();
            qq = '"';
            StringBuilder sb = new StringBuilder();
            sb.Append("<?xml version=");
            sb.Append(qq);
            sb.Append("1.0");

same for sql