• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database in Jsp

 
velgapudi suresh
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

Thnks
Suresh Velagapudi
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to our JDBC forum (which is the best place for a question like this).
 
Renato Losio
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic