How to Retrive '_ ' from database

[natesa raj]

hi i have been facing issues in retreiving '_'(under score )from the database.

how i can do that?

[Srinivasa Raghavan]

Use a escape character to escape '_'
like this.
SELECT * FROM emp WHERE name like '\_%' ESCAPE '\';