>Hi
>
>In one Table i have code , ValDeb N(10,2) , ValCre N(10,2)
>
>One record can have this
>
>Code1 , 50.00 , 20.00
>
>another example
>
>Code2 , 25.00 , 0.00
>
>I want make one select , where result is :
>
>Code1 , 50.00 , 0.00
>Code1 , 0 , 20.00
>Code2 , 25.00 , 0.00
>
>Do you understand ?
>
>Thanks

Select pkid, f1, f2*0 as f2 from myTable where f1 # 0  ;
 union ;
 Select pkid, f1*0 as f1, f2 from myTable where f2 # 0 ;
 order by 1,2 desc

Cetin