hi, I am writing a stored proc that is getting a value from input. and I have to search a table using that input.
where col1 LIKE %inputvar%
I dont' know how to do it.
I used all these things but nothing is working:
a. where col1 LIKE %inputvar%
b. where col1 LIKE '%' || inputvar || '%'
any help is greatly appreciated.