Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    266

    Unanswered: User NOT LIKE (alpha)

    Hi

    for MS SQL 2000

    I am searching users for each letter

    WHERE users.name LIKE ('A%')

    how can i search For users.name not starting by A to Z ? all except letters

    thank you

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    where name not like '[A-Z]%'

  3. #3
    Join Date
    Dec 2005
    Posts
    266
    perfect

    thanks a lot

Posting Permissions

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