Try Upper(PERS_NAME) = 'SMITH' in case the case got screwed up in the
transfer
In article <7dlsuf$dft$1_at_nnrp1.dejanews.com>, vpanzer_at_my-dejanews.com
writes
>I migrated an Access-DB-Table with an AutoValue ID-Field called PERSID to
>Oracle 8. The SQL-Command "select PERSID from T_TABLE where PERS_NAME =
>'Smith'" produces no result (select PERS_STREET ... works fine).
>
>What's wrong ?
>
>Thank you for your friendly help!
>
>Volker
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
--
Diane
Received on Sun Mar 28 1999 - 13:53:56 CST
