>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


MIN() in select is differenbt that MIN() native function. MIN() in select get the minimum value of the Field passed as parameter, so it accept only one parameter.
If you want to simulate MIN in select you could use:

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, ;
	IIF(linkfile.A<linkfile.B, 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