retreiving underscore.....

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.