Personal tools
You are here: Home → DB2 → How To's → How to ignore case sensitive search on DB2
Navigation
Log in


Forgot your password?
 
Document Actions

How to ignore case sensitive search on DB2

using the upper or lower functions

Example:

db2 "select FIRSTNME from db2inst1.employee "


FIRSTNME   
------------  
Michael    
Sally          
Eva         
Delores     

 

db2 "select FIRSTNME from db2inst1.employee where upper(FIRSTNME) like 'EVA' "

 

FIRSTNME   
------------
EVA        


Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls