The Oracle wild cards for the LIKE operator are % and _ (underscore). The percent sign is like an asterisk while the underscore is position wildcard
LIKE 'TESTLAST%' returns all matches that start with TESTLAST
LIKE '%LAST%' returns any rows with LAST anywhere in the string.
>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
Mark McCasland
Midlothian, TX USA