Urgent:Help on SQL

This is a multi-part message in MIME format. ------=_NextPartTM-000-2f6723a0-76ba-4ebb-90ed-9ecea500c431 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I am running the following SQL on Redbrick 6.1 OS - AIX 4.3: select ia_sk_SKU_key,hs_department_number from dim_sku whereia_sku_level=3D'De-BRAND' and dim_sku.hs_department_number not in = (select distinct int(DEPARTMENT_NUMBER) from STAGE_STAT_LINE_ITEMS); Here the hs_department_number is of type SMALLINT department_number is of type CHAR(5). Logically I should be getting a big result set, however I donot get any results. When I run the same query by removing the not clause I get the expected result set.=20 Is there something I am missing here? Your comments/suggesttions are most welcome. TIA, Asheesh. ------=_NextPartTM-000-2f6723a0-76ba-4ebb-90ed-9ecea500c431 Content-Type: text/plain; name="InterScan_Disclaimer.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="InterScan_Disclaimer.txt" This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com ------=_NextPartTM-000-2f6723a0-76ba-4ebb-90ed-9ecea500c431-- sending to informix-list