I dont get this...

Hi,

I dont quite understand why the below queries are behaving this way. profile is of type number and nickname is of type varchar2. I select profile based on the pattern 'kc\_%' (escaping _ with \) and have 21 hits. But when i further qualify with profile=1, i get zilch. Why? I'm puzzled and need your help. Thanks..

Regards,
Calvin

SQL> select profile from user_profile where nickname like 'kc\_%' escape '\';

PROFILE

           1
           1
           1
           1
           1
           1
           1
           1
           1
           1
           1

PROFILE

           1
           1
           1
           1
           1
           1
           1
           1
           1
           1

21 rows selected.

SQL> select profile from user_profile where nickname like 'kc\_%' escape '\'

and                 profile=1;

no rows selected

-----BEGIN PGP PUBLIC KEY BLOCK-----

Version: PGPfreeware 6.0.2i

mQENAziIKPcAAAEIAMOziD1YcgivJCdmdMaQftSrMhnL6uXjz9Fh6c2FjDbEwLb1 gHAYk8bdlaWLPspacuwo5mjzCc5uUvNualORP+tLxGNY9GiMdHMUfUdNLxv7EU4+ 6WxaXwyzz5DZUQiwLsvg12+ZSLOuOL4BLu8oJH9MBSPa/9aaYGDpQ845L6JJP5t1 uDDsG26k6gnenOfT+ZaEgFTFpYQbfXN7X16dc726AcEuSG8NUjK3thA3ol9m8768 cCELkc82w55HNH5b4TeF9obapJrXgOLqnf2pi4mUodao5dFewW/U46zPcz2giRp4 gVPAmJFs+s8OjKY74D3aXH7QWg7bLrLOrBG3pkUABRG0L0NhbHZpbiBMaW0gU3dl ZSBLaGlhbmcgPGNhbHZpbl9saW1AaG90bWFpbC5jb20+iQEVAwUQOIgo9y6yzqwR t6ZFAQFrTAf+Lw6aI0wSfOooU1n9qw0zdL4o0U4ZH+XAgzn8BoVcv0U1bA0U1ckg pDY5TVfR0hQg7DQyUvh1AKxeD9D6OTFpg/TE3BPD49iq/LS3uuUbfIGmhsE6AmM1 SiRwwmA5n5IZTWDYHrocBJegV5Hk3iHJeDjCKvX/CZCZH4CGJ/2y/THfa6I9eDfF kmZ8f90cM4hZ9YiqLSslNf5hztJZzEfBuSs7Zz6tHRQFlCucn5mlKPNM+ig4FBdS f6ISUMxQxZB2xbFwYDn+qjB6eF8HianPP7XCQUSQNJeWKQ9pkJ7QOZeEKvRYZHp2 tLNw34pJ8cHoOIGS7FAi+OX2IfyyOvehkw== Received on Fri Jun 16 2000 - 15:47:13 CDT