>Hi:
>
>I have two Oracle databases, one is at the client site and the other is at our office. Both are populated with the same tables and data.
>
>I run the following SQL command in enterprise manager:
>
>SELECT * FROM VW_PERSON_PROFILE_BY_NAME WHERE UPPER(FULL_NM) LIKE 'TESTLAST, DALE W'
>
>At our office, the results return one record, but on the client site the result returns zero records. Is there a setting in Oracle that would cause the LIKE operator to behave differently?
>
>Thanks!
Hi Paul,
I don't think there is a setting, I'll ask my colleague who worked with Oracle.
I also suggest you to ask this question in SQL Server forum, because Oracle forum here doesn't have much traffic and I don't think many people have this forum in their profile.
If it's not broken, fix it until it is.
My Blog