Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    47

    Question Unanswered: oracle string handling

    hai can u just suggest me how to select all names which has for example a as a character in it.

    Thanx

    sundar.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: oracle string handling

    Originally posted by sundarr123123
    hai can u just suggest me how to select all names which has for example a as a character in it.

    Thanx

    sundar.
    This will find any name with a lower case 'a' in it:

    select name
    from mytable
    where name like '%a%';

    If you want to find both 'A' and 'a' then you could do either of:

    select name
    from mytable
    where name like '%a%'
    or name like '%A%';

    select name
    from mytable
    where upper(name) like '%A%';

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •