Forum Stats

  • 3,816,311 Users
  • 2,259,169 Discussions
  • 7,893,452 Comments

Discussions

query on where condition - upper(rtrim(column)) = ?

663506
663506 Member Posts: 26
edited Oct 14, 2008 8:54AM in SQL & PL/SQL
Hi,

I have a table StudentGrades. This table has an index on the column "grade" of type varchar2.
The values of "grade" column contain string values like: 'A', 'a', 'A ', 'a ', 'A ', i.e. mixed cases and containing white spaces at times.

If I run a query below, will it use the index on grade?

select * from StudentGrades where upper(rtrim(grade)) = ?

where ? is an input parameter from the program and the value has been trimmed and converted to uppercase.

Thanks,
Jason
Tagged:

Answers

This discussion has been closed.