|
Hi All,
I am facing a very strange problem,
I am firing the following query to my Oracle
database:
SELECT DISTINCT a.SC_CONT_EMAIL
FROM SCAT_CONTACT a, scat_customer b
WHERE a.sc_customer_id=b.sc_customer_id
AND a.SC_CONT_LAST_NAME = N'小島'
AND b.sc_cust_password is not null
This query works fine for all the names in my
database except for a few.
These names are
1) 三上
2) 川村
3) 河島
Can somebody please guide me, what could be the
possible cause for the query not working fine for the above mentioned names
?
Thanks a lot.
Regards
Ashutosh Sangle.
|
