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!

--Paul