Using character strings in where clause when linking to Oracle

• Bill Wagman

  SSCommitted

  Points: 1763

  More actions

  March 17, 2006 at 3:49 pm

  #112322

  Greetings, I am running sql server 2000 and attempting to link to an oracle 10g database running on Linux and use character strings in the where clause;

  select

  a.mothraid as PersonID,

  null as UNIQUE_ID,

  a.loginid as LoginID,

  a.ucd_pi_source as PiCategoryCode,

  a.firstname as fname,

  a.lastname as lname,

  a.middleinitial as mi,

  a.suffix as Suffix,

  a.deptcode as DeptCode,

  a.email_address as Email,

  CASE a.undergrad WHEN '1' THEN '0' ELSE '1' END as inv,

  a.ikrb as Login

  from OPENQUERY(MOTHRA,

   'select *

    from MOTHRA.INFOED_PEOPLE where mothraid not in ('00350077', '00072066')') a

   

  It appears that the quotes surrounding the character strings are being interpreted as a quote at the end of the statement. mothraid is a varchar variable. I can't figure out how to do this, can anyone help?

  Thanks.

• Sergiy

  SSC Guru

  Points: 110192

  More actions

  March 19, 2006 at 9:22 pm

  #627496

  from OPENQUERY(MOTHRA,

   'select *

    from MOTHRA.INFOED_PEOPLE where mothraid not in (''00350077'', ''00072066'')') a

  _____________
  Code for TallyGenerator