quotation in conditional name - script

[arsenal1983]

Hi,

I need to import the data set with condition:

where

[Rating Description])= 'MOODY'S LONG-TERM ISSUER RATING'

I get an error because of the quotation mark in MOODY'S

How I can handle with this?

Luke

[Anil_Babu_Samineni · Accepted solution]

May be this?

where [Rating Description]= 'MOODY''S LONG-TERM ISSUER RATING'

[sunny_talwar]

Or this

Where WildMatch([Rating Description], 'MOODY*S LONG-TERM ISSUER RATING'

or

Where WildMatch([Rating Description], 'MOODY?S LONG-TERM ISSUER RATING'

[Miguel_Angel_Baeyens]

I usually replace these values during the load for a character or string I know for sure this field, say

...

Replace([Rating Description], Chr(39), '$$$') AS [Rating Description],

...

So now instead of ' you will have $$$, which is easier to find, replace, and even remove in a later step in the script prior to displaying data.

Other options:

'MOODY''S LONG-TERM ISSUER RATING' // see the double single quote to "escape" the ' character

'MOODY' & Chr(39) & 'S LONG-TERM ISSUER RATING' // use the ASCII Chr() function

[sasiparupudi1]

where

[Rating Description])=

'MOODY'&chr(39)&'S LONG-TERM ISSUER RATING'