Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes Database in Jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Database in Jsp" Watch "Database in Jsp" New topic

Database in Jsp

velgapudi suresh
Ranch Hand

Joined: Aug 11, 2006
Posts: 32
Hi All,

I have small problem. In SQL how v can retrive the characters without case sensitiveness in Oracle 10g.
my sql is : select name from emp where name like'w%';

but i want upper value and lower value....

anybody help me to solve

Suresh Velagapudi
Ben Souther

Joined: Dec 11, 2004
Posts: 13410

Moving to our JDBC forum (which is the best place for a question like this).

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Renato Losio
Ranch Hand

Joined: Nov 23, 2005
Posts: 99
You may do something like:

select name from emp where upper(name) like'W%';

but watch out for performances as you won't use any index defined on the name column.

Renato Losio - -
I agree. Here's the link:
subject: Database in Jsp
It's not a secret anymore!