Hi Friends,
I have a search option in my web page. My input from UI is any thing like alphabets,numbers, special chars(%$#_). My query is select * from vendor where vendor_name like 'vendorname%'; The condition input is(vendorname) anything. Based on the input i have to display the results. My query is working fine for all conditions except the input % and _. B'coz, these values are wild cards in Database. How can I send as a String in database if the values are %_. I'm using Java, J2ee and DB2. Please help me.
Regards
Kasi.


Regards
Kasi

__________________
Regards
Kasi

i m not sure but try backwork slash before special character

if user input is abd_dcd then replace(userinput,"_","\_")
if user input is abd_dcd then replace(userinput,"_","\_")

find proper syntax for replace function in front end you are using

urt

Help yourself by helping someone.