|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
March 3rd, 2005, 03:16 PM
|
|||
|
|||
|
Case sensitive issue
I'm not 100% sure if I should be asking this Forum or the ColdFusion forum. But since my code in question is an SQL statement accessing an Oracle Database, I figured here was the best place. If not, let me know.
I'm running a search using ColdFusion. One of the items a user can search for is a person's name or part of the person's name. However, if I search for "George" I will only get results that have a capital "G" and lower-case "eorge" That is, any results not matching the case exactly are ommitted. My code is: WHERE staff_name LIKE '%George%' Is there something that I can do to tell it to pull up all results regardless of case?
|
|
#2
March 3rd, 2005, 03:35 PM
|
|||
|
|||
|
UPPER()
Code:
WHERE UPPER(staff_name) LIKE '%GEORGE%' There is also LOWER() if you'd like that better
|
|
#3
March 4th, 2005, 12:59 PM
|
|||
|
|||
|
Quote:
That's perfect. Thanks!
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Case sensitive issue |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
