OK. Thanks to both of you. I think I can work it out now.

>You cannot use VFP MIN() function in SQL because it has its own aggrefate MIN() function.
>

	IIF(linkfile.A < linkfile.B, linkfile.A, linkfile.B) as lh_node,;
>

>
>
>>The following command works fine:
>>

>>select linkfile.*, aNodes.x as x1, aNodes.y as y1,;
>>	bNodes.x as x2, bNodes.y as y2,;
>>	abs(aNodes.x-bNodes.x) as dx, abs(aNodes.y-bNodes.y) as dy,;
>>	'  ' as stddir, ;
>>	'  ' as lh_node,;
>>	.f. as _used ;
>>	from linkfile ;
>>	left join (lcNodefile) aNodes on linkfile.A == aNodes.n ;
>>	left join (lcNodefile) bNodes on linkfile.B == bNodes.n ;
>>	where st_name <> ' ' ;
>>	order by st_name ;
>>	into cursor crsOriginalLinks readwrite
>>

>>but when I change the 5th line to
>>

>>select linkfile.*, aNodes.x as x1, aNodes.y as y1,;
>>	bNodes.x as x2, bNodes.y as y2,;
>>	abs(aNodes.x-bNodes.x) as dx, abs(aNodes.y-bNodes.y) as dy,;
>>	'  ' as stddir, ;
>>	min(linkfile.A,linkfile.B) as lh_node,;
>>	.f. as _used ;
>>	from linkfile ;
>>	left join (lcNodefile) aNodes on linkfile.A == aNodes.n ;
>>	left join (lcNodefile) bNodes on linkfile.B == bNodes.n ;
>>	where st_name <> ' ' ;
>>	order by st_name ;
>>	into cursor crsOriginalLinks readwrite
>>

>>I get an error on the changed line that says "Function name is missing ')'." Any suggestions as to what is happening and how to fix it?
>>
>>Thanks