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