Code: Select all
BO.Text1+' '+BO.Text2
Code: Select all
BO.Text1+' '+BO.Text2
We use this sort of concatenation frequently. Should work.
We use AS_STRING when numbers (maybe dates too?) are involved in concatenation.PointsWell wrote: ↑Mon Sep 20, 2021 7:39 am The issue is that AIM is not dealing with Numbers in a consistent manner:
Concatenations of Numbers with Strings should treat the result as a String.
It does not in Query Calculations. It is stripping the extra space.