Hi,It is possible to mixed selected row? I have tables – (it is product recepture for assembly device). DefCREATE TABLE [base] ([heft] INT, [vde] BOOL, [Prumer] FLOAT, [Delka] FLOAT, [M1P1] FLOAT, [M1P2] FLOAT, [M1P3] FLOAT, [M2P1] FLOAT, [M2P2] FLOAT);
DATA:RecNo heft vde Prumer Delka M1P1 M1P2 M1P3 M2P1 M2P2 ----- ------ ------ ------ ------ ------ ------ ------ ------ ------ 1 (null) (null) (null) (null) (null) 100 50 (null) (null) 2 81 False (null) (null) 12.1 (null) 45.1 14.1 12 3 81 (null) 3 (null) 13 (null) (null) 16.2 12.4
„Heft“ is main name of variant. RecNo 1 is general options it possible to set default vaule for all product. (heft is NULL)„Prumer“ and „Delka“ is can determine specification of product. Rec No. Is representation of variant „81“ it is default value. „Prumer“ and „Delka“ is NULL.How to SELECT row 4 and mixed with row 1,2 ( replace parameter null M1P1, M1P2 … descending ). Now I do this on side of application. 
Select mixed row
Posted - 2012-09-27 : 02:11:37
