nField ------ 10 20 30 110 98What do you want the result set be ?
nField
------
99
99
99
110
99
*Or :
nField
------
110
If the latter one :CREATE CURSOR myTest (f1 i, f2 i, f3 i) INSERT INTO myTest VALUES (10,20,30) INSERT INTO myTest VALUES (20,30,40) INSERT INTO myTest VALUES (30,40,50) INSERT INTO myTest VALUES (40,50,60) INSERT INTO myTest VALUES (120,20,70) INSERT INTO myTest VALUES (50,60,70) SELECT *, myMAX(f1,f2,f3) as myMax FROM myTest FUNCTION myMax LPARAMETERS p1,p2,p3 RETURN MAX(99,p1,p2,p3)*1Or have a unique field and group on it (to make SQL max work on indiviual records). ie:
CREATE CURSOR myTest (pkID i, f1 i, f2 i, f3 i) INSERT INTO myTest VALUES (1,10,20,30) INSERT INTO myTest VALUES (2,20,30,40) INSERT INTO myTest VALUES (3,30,40,50) INSERT INTO myTest VALUES (4,40,50,60) INSERT INTO myTest VALUES (5,120,20,70) INSERT INTO myTest VALUES (6,50,60,70) SELECT *, MAX(MAX(99,f1,f2,f3)*1) as myMax FROM myTest GROUP BY pkIDCetin