Hi Ashley,

Try the following:

SELECT EVAL(FIELD(1)) AS FieldName....

and see if it helps.

>If I have a remote table with a field name of 1st2ndDeathBenefit. How do I select from that table by aliasing the field name into something fox understands. I have tried:
>
>Select "1st2ndDeathbeneft" as DeathBenefit
>Select '1st2ndDeathbeneft' as DeathBenefit
>Select (1st2ndDeathbeneft) as DeathBenefit
>Select Eval(1st2ndDeathbeneft) as DeathBenefit
>Select &1st2ndDeathbeneft as DeathBenefit
>
>all to no avail. Does anyine have any ideas?
>
>Ashley
>AssureSoft Ltd