Thread: Wildcards

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Germany
    Posts
    9
    Rep Power
    0

    Unhappy Wildcards


    Does Firebird support Wildcards and if yes, how?

    The ANSI-Wildcard-Symbol (%) is NOT Supported! :-(
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    select * from person
    where name like 'A%';

    works for me.

    Be aware that firebird is case sensitiv! like 'a%' is something different then like 'A%'
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Germany
    Posts
    9
    Rep Power
    0

    thanks


    i've tried something like

    SELECT * FROM Person WHERE name LIKE 'a%'

    but i don't knew that firebird ist case sensitive. Thanks a lot. Maybe that's the Problem!

IMN logo majestic logo threadwatch logo seochat tools logo