Script prob

[nikhilgarg]

Hey,

My script is:

Load CityId,

Cityname

CountryCode

from abc.qvd ;

i want to apply condn where Country Code = US and CA

I applied like:

Load CityId,

Cityname

CountryCode

from abc.qvd  where CountryCode = {'US' , 'CA'} ;  but giving error.

[tresesco]

No.  'CountryCode = Match(CountryCode, 'US', 'CA') ;   Try exactly how I showed above. For clearing doubt, read help for Match()