Results 1 to 5 of 5

Thread: retreiving underscore.....

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Contributing Member
    Join Date
    Sep 2006
    Answers
    962

    retreiving underscore.....

    how can i retreiving '_'(under score )from the database ? plz help with this.

    --------------------
    suresh


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: retreiving underscore.....

    Please check this sample code

    Code:
    select * from emp where ename like '%\_%' escape '\';
    hope that solves your problem.


  3. #3
    Contributing Member
    Join Date
    Sep 2006
    Answers
    962

    Re: retreiving underscore.....

    yes it is working fine...Thanks debasisdas.


  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: retreiving underscore.....

    you are most welcome.


  5. #5
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: retreiving underscore.....

    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact