Results 1 to 2 of 2

Thread: string question

  1. #1
    Join Date
    Nov 2004
    Posts
    27

    Unanswered: string question

    Greetings all,

    If I have a clause in the where statement that looks like this:

    select CUSTOMER_FIRST_NAME
    from CUSTOMER
    where CUSTOMER_FIRST_NAME like '__'

    How can I retrieve those first names made up of only two alpha characters, excluding any spaces? Any help would be appreciated.

    Thanks,

    Patrick Quinn

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1

    retrieve if only two alpha characters

    select CUSTOMER_FIRST_NAME
    from CUSTOMER
    where CUSTOMER_FIRST_NAME like '[A-Za-z][A-Za-z]'

Posting Permissions

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