Single Quote ( ' ) problem in SQL

From: Ajay M. Kakade <amkakade_at_openix.com>
Date: 1997/03/10
Message-ID: <5g1i4s$5mq$1@spasmolytic.openix.com>#1/1

I have a main table A and contains a column Name. For this column Name I have a lookup table. In many of the names there is a single quote present for example O'Conner. In my application I display a list of Names from the lookup table. When the user selects names like O'Conner a dynamic SQL is generated which looks like

        Select blah, blah, blah 
        From A
        where Name = 'O'Conner';

This bombs with an error. The biggest consideration is that all my queries are generated dynamically using some algorithm which would select rows from tables and generate a SQL from the users input. So I do not have much control over the query.
Has somebody got a solution for this Single Quote Problem. I would be grateful if somebody would share a solution with me.

Thanks in advance.

Ajay Kakade Received on Mon Mar 10 1997 - 00:00:00 CST