Results 1 to 2 of 2

Thread: Like Comparison

  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: Like Comparison

    Hello Everyone

    I am using the like Comparison to get a result from a column in POSTGRESQL.
    The problem is that i can't retrieve the records who are not beginning with the charachter A to Z. I've tried many things.

    EXAMPLE:

    select name from company where name ~* '[^A-Z]%';

    Can Someone help

    Thanks in Advance,

    Chris

  2. #2
    Join Date
    May 2004
    Posts
    2

    Answer

    Hi

    I found the answer by an other forum.

    select name from company where name similar to '[^A-Z]%';

    the other which should work any where is

    select name from company where name ~ '^[^A-Z]';

    greetz Chris

Posting Permissions

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