Results 1 to 6 of 6

Thread: Filter needed!

  1. #1
    Join Date
    May 2008
    Posts
    3

    Wink Unanswered: Filter needed!

    Hi friends,

    My question is about filtering in Informix.. I have a name that includes a special characters or strings,,and want to take out these unwanteds from names. For instances,

    NewYork_SAD or Newyork_MOB----->>> I wanna clean out strings which includes this kind of extensions.

    I mean are there any "does not contain" filter in İnformix sql?

    Best regards.

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    Give an example of what exactly you want.

    regards,

    Nitin

  3. #3
    Join Date
    May 2008
    Posts
    3
    I did but ok for example,

    Table

    Newyork
    Newyork_MOB
    DC
    DC_KIN

    When I try to bring these 4 objects through a filter that I use take only Newyork and DC not Newyork_MOB and DC_KIN..

    Just like that not equal "_MOB" and "_KIN" ????

  4. #4
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    this "filter" ... what you want mean exactly ??????

    This is a SQL ?
    This is a component of some program language?
    This is inside some application ?
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  5. #5
    Join Date
    May 2008
    Posts
    3
    Yeah I mean SQL,,

    Thats the structure what I mean;

    SELECT prod_name, prod_price

    FROM Products

    WHERE prod_price = 3.49;

    Order By prod_name


    In this structure before the "order by" filtering data make sense?

  6. #6
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    yes, only remove the ";" from the where and put after the "order by prod_name" :
    Code:
    SELECT prod_name, prod_price
    
    FROM Products
    
    WHERE prod_price = 3.49
    
    Order By prod_name;
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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