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

    Join Date
    Jul 2003
    Location
    malaysia
    Posts
    13
    Rep Power
    0

    Question sql statement issue


    platform : xp pro / Visual studio 2002 / firebird.net

    I want to retrieve all records that name contain a certain string , how should I do it ?
    ( This is like a search option )
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    malaysia
    Posts
    13
    Rep Power
    0
    ok I find my answer : select name from table where name like %bush%
    Then , how to add 2 string field in a statement
    my code
    'select (addr1+addr2) as address' , it gives error .
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    Firebird uses the double pipe for concatenation.
    select addr1 || addr2
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    malaysia
    Posts
    13
    Rep Power
    0
    Thank you ,it works fine

IMN logo majestic logo threadwatch logo seochat tools logo