LIKE and Oracle

I never spotted this before but the LIKE operator is case sensitive! Which was skewing my search results quite severely. The work around is to put everything into upper case, both the values in the column you are performing the search against as well as the value of the varibale you are searching for.

PLAIN TEXT
CODE:
  1. SELECT col1, col2, col3
  2. FROM table
  3. WHERE UPPER(col4) LIKE '%UPPER(yourValue)%'

About this entry

You’re currently reading “LIKE and Oracle,” an entry on gregs

Published:
Friday, October 21st, 2005 at 12:00 am
Author:
gregs
Category:
Uncategorized