Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Posts
    16

    Unanswered: Can you tell me what this is called?

    I have a list of first names and I need to query all the ones that end in a certain letter. I'm not sure what you would call this so I don't really know what I'm looking for. I would be grateful for any guidance.

  2. #2
    Join Date
    Jan 2012
    Posts
    16
    Nevermind I found what I'm looking for.. I'll use the wildcard

    SELECT *
    FROM table_name
    WHERE fname LIKE '%A';

    I'll put it here just in case someone else needs it.

    Thanks!

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Two more options for you:
    Code:
    where regexp_like(fname, 'A$')
    
    where substr(fname, -1) = 'A'

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    and of course if the lname ends in a lower case a then

    SELECT *
    FROM table_name
    WHERE upper(fname) LIKE '%A';
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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