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.

Give an example of what exactly you want.

regards,

Nitin

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" ????

this "filter" ... what you want mean exactly ??????

This is a SQL ?
This is a component of some program language?
This is inside some application ?

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?

yes, only remove the ";" from the where and put after the "order by prod_name" :