Skip to Content
Former Member
Jan 21, 2008 at 03:55 PM

Convert both parameter and table value to Upper case in Select statement


I have a select statement with where clause. I want to make it not case sensitive. I want to able to convert the value coming form table to upper case and compare it against the parameter that is converted to upper case.

Can some one please give me syntax for that. I know in ABAP there is TRANSLATE statement but I am not sure how to use it in Where clause.


WHERE UPPERCASE(fieldName) like UPPERCASE(parameter)