Query Question

[Shawn M]

I have a query that is hanging me up, so I am looking for help.

I am pulling form a fox-pro table and putting the data in a sql server 6.5
table, with a query to see if it exists already or not, then add it to the
table.

my program errors out on a
SELECT * FROM trans_country WHERE Country='People's Rep Korea'

I know this can go into the database but the query to search for it isn't
working due to the multiple single quotes.

Any suggestions would be appreciated?

[Shawn M]

"DaveSatz" <davidsatz@yahoo.com> wrote:
>SELECT * FROM trans_country WHERE Country="People's Rep Korea"

I create this select string from a list on another database, and I do this
suggestion and I get an error in my select "Invalid Column Name" from the
exception engine in my VC++ application on the open of the record set that
contains the select statement.

Any Other Suggestions?

[DaveSatz]

SELECT * FROM trans_country WHERE Country="People's Rep Korea"

--
Thanks,
David Satz
Principal Software Engineer
Hyperion Solutions
->Using SQL Server 7.0 SP2/6.5 SP5a/Cold Fusion 4.5.1/ADO 2.1/VB 6.0/MTS
(Please reply to group)
-----------------------------------------------------------------

"Shawn M" <smiller@duke.com> wrote in message
news:39fddaf6$1@news.devx.com...
>
> I have a query that is hanging me up, so I am looking for help.
>
> I am pulling form a fox-pro table and putting the data in a sql server 6.5
> table, with a query to see if it exists already or not, then add it to the
> table.
>
> my program errors out on a
> SELECT * FROM trans_country WHERE Country='People's Rep Korea'
>
> I know this can go into the database but the query to search for it isn't
> working due to the multiple single quotes.
>
> Any suggestions would be appreciated?

[DaveSatz]

SET QUOTED_IDENTIFIER OFF
before executing select

"Shawn M" <smiller@duke.com> wrote in message
news:39fddfbd$1@news.devx.com...
>
> "DaveSatz" <davidsatz@yahoo.com> wrote:
> >SELECT * FROM trans_country WHERE Country="People's Rep Korea"
>
> I create this select string from a list on another database, and I do this
> suggestion and I get an error in my select "Invalid Column Name" from the
> exception engine in my VC++ application on the open of the record set that
> contains the select statement.
>
> Any Other Suggestions?

[dsl]

SELECT * FROM trans_country WHERE Country='People''s Rep Korea'