# 277 Total Size Not Being Correctly Calculated for Concatenated String Fields in SQL Columns List

---

It appears that if you use SELECT and select a text expression (say two columns concatenated) to produce a computed value, and you have established a persistent field object, then the Size property of the field object must exactly match the sum of the length of the fields in the expression. If not, you get an error and the query can't execute.

This causes problems in cases where you want to conctenate some litersl text into the expression, or where you may want to repeat the query with a different actual expression. It would be better if the results of the expression were simply put into the field regardless of whether the lengths matched or not--if the field object size were too small, of course the text wouldc be truncated.