Hi all,
I have program which use SQL in source. I use "LIKE.... %xx%", it runs ok, but it only shows the search results lowercase if I input lowercase character and other.
I dont know how to show all cases include uppercase and lowercase in the search results.
I use AS/SET tool of SSA Global Technologies Company.
My code attached.
Do "LIKE" SQL in DB2 separate between uppercase and lowercase characters? (Is it is difference with MS.Access, Oracle...?)
Thanks for reply!
I have program which use SQL in source. I use "LIKE.... %xx%", it runs ok, but it only shows the search results lowercase if I input lowercase character and other.
I dont know how to show all cases include uppercase and lowercase in the search results.
I use AS/SET tool of SSA Global Technologies Company.
My code attached.
Do "LIKE" SQL in DB2 separate between uppercase and lowercase characters? (Is it is difference with MS.Access, Oracle...?)
Thanks for reply!
Comment