Hi Pedro
I dont know if this is a perfect solution but try it
CREATE CURSOR test;
(code c(4),db n(10,2),cr n(10,2))
INSERT INTO test VALUES ('c1',500,0)
iNSERT INTO test VALUES ('c1',0,25)
iNSERT INTO test VALUES ('c2',250,0)
SELECT code,db,cr FROM test WHERE db>0 UNION select code,db,cr FROM test WHERE cr>0
hth
>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