> >SELECT cFld AS FieldDisplayName FROM tablename ...
> >

That statement should work. If it doesn't work, then check that

1) It works ok without the "AS FieldDisplayName"
2) You are not trying to use a reserved SQL word as your FieldDisplayName