Do not select individual columns in a query if also using a built-in function.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
Resolution:
Create a select list that either names individual columns or lists columns
with built-in functions applied to them; do not include both in one select
list.