how can i retreiving '_'(under score )from the database ? plz help with this.
--------------------
suresh
Printable View
how can i retreiving '_'(under score )from the database ? plz help with this.
--------------------
suresh
Please check this sample code
[code]select * from emp where ename like '%\_%' escape '\';[/code]
hope that solves your problem.
yes it is working fine...Thanks debasisdas.
you are most welcome.
In place of using \ we can use any other character as the escape .
The only restriction is that escape character can't be used in the search criteria.