Oracle Forms

I have data that have mixed cases. However, when I search using Oracle forms, it is case sensitive.

For example:

Sample Data: Team Member Name = 'Brian', 'Brian Smith'

If I press enter query and key in 'Bri%', data will be retrieved. However if I use 'BRI%', no record will be retrieved. It has to be case sensitive. But there are like thousands of rows and I have no idea how data were encoded.

There is no option to put all text to the same case and there is also no option to change the parameter nls_comp and nls_sort to solve this issue. I already placed the following code and the searching is still case sensitive.

PROCEDURE FPRC_NONCASE_SORT IS
vWhere_Str VARCHAR2(2000) := NULL;
BEGIN

IF :TEAM_MEMBER_NAME IS NOT NULL THEN
vWhere_Str := ' UPPER(team_member_name) LIKE ''%' || upper(:TEAM_MEMBER_NAME) || '%''';
END IF;

SET_BLOCK_PROPERTY('TEAM_MEMBER', DEFAULT_WHERE, vWhere_Str);

end;

I'd really really appreciate it if someone can help me on this. When I take the like clause out in sql plus, it works...I don't know why it's not working on forms. If someone has experienced the same thing, please let me know. Thanks!