Hello all -
Here is the data sample:
ssn: zip country_code
---------------------------------
123456789, " ", TU
999999999, 10003, USA
555555555, " ", "" should not be on the outfile
666666666,"07036", ""
I need to extract the data for the mailing purposes & select records with not null zip codes only for records with blank or USA country_codes.
If the country_code is USA or blank zip_code should not be null. How do I code it?
Please help!
cristi
Here is the data sample:
ssn: zip country_code
---------------------------------
123456789, " ", TU
999999999, 10003, USA
555555555, " ", "" should not be on the outfile
666666666,"07036", ""
I need to extract the data for the mailing purposes & select records with not null zip codes only for records with blank or USA country_codes.
If the country_code is USA or blank zip_code should not be null. How do I code it?
Code:
select member_key ,zip_code,country_code from member
where ? zip_code is not null ... in case when country code is USA or NULL
Please help!
cristi