>hi all,
>
>i need to select as ==2 , == 3 ...4, and ==18...etc
>
>from injaz1 ;
> WHERE typ1 In (' 2',' 3',' 4',' 18') ;
>
>thanks
I suggest to create a cursor with every type as a record and JOIN with that cursor. It should be better than Type IN (...)
If it's not broken, fix it until it is.
My Blog