Oracle - gregs

Home
comps
- *nix
- browser
- ColdFusion
- CSS
- database
- eclipse
- email
- google
- JavaScript
- linode
- log
- mac
- maps
- parse
- rendering
- tdd
- vmware
- web server
RL
- photos
svn
tumble
Uncategorized

Oracle

LIKE and Oracle

by gregs on Oct.21, 2005, under Oracle, database

Famvir For Sale Lotrisone No Prescription Buy High Love No Prescription Buy Online Prinivil Buy Zimulti Online Mentax For Sale Zelnorm No Prescription Buy Shoot No Prescription Buy Online Naprosyn Buy Flomax Online Adalat For Sale Erythromycin No Prescription Buy Medrol No Prescription Buy Online Urispas Buy Lotrisone Online Viramune For Sale Didronel No Prescription Buy Speman No Prescription Buy Online Prandin Buy Colchicine Online Amitriptyline For Sale Lopressor No Prescription Buy Rhinocort No Prescription Buy Online Atarax Buy Pamelor Online

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.

CODE:

SELECT col1, col2, col3
FROM table
WHERE UPPER(col4) LIKE '%UPPER(yourValue)%'

Leave a Comment more...

Howdy. Welcome to gregs!
Thanks for dropping by! Feel free to join the discussion by leaving comments, and stay updated by subscribing to the RSS feed. See ya around!
Del.icio.us
- 3D graphics & reality fuse on the fly - University of Oxford
What I'm Doing...
- @jcinnamond we were thinking of checking out your neck of the woods, but after the crime spree, maybe not???? :P in reply to jcinnamond 1 day ago
- Another release done, but seriously the novelty is really wearing thin.. as are the late nights... 1 week ago
- hates timesheets.... 1 week ago
- More updates...
Posting tweet...
Powered by Twitter Tools.

Categories
- comps
  - *nix
    - debian
  - browser
  - ColdFusion
  - CSS
  - database
    - MS SQL
    - MySQL
    - Oracle
  - eclipse
  - email
    - sendmail
  - google
  - JavaScript
  - linode
  - log
  - mac
    - os x
  - maps
  - parse
  - rendering
  - tdd
  - vmware
  - web server
    - apache
    - iis
- RL
  - photos
- svn
- tumble
- Uncategorized

Meta
- Log in
- Valid XHTML

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Visit our friends!

A few highly recommended friends...

Archives

All entries, chronologically...