Hi Benn,

* for MS Access 
=SQLEXEC(x,"SELECT [as-rno] as as_rno from table")

* Other ? I don't known.
=SQLEXEC(x,[SELECT "as-rno" as as_rno from table])

MartinJ

>Hi,
>
>I have to select a field from a remote table that contains a '-' in the fieldname (as-rno). The SQLEXEC() returns an error on this field.
>
>How do I fix this problem ??????
>
>Best regards
>Benn