Reported By: Lawrence Lustig Reported On: 2/3/1999 For: Version 1.09 Build 1
# 276Concatenation of String Fields in SQL Expression Engine Not Working Properly An apparent problem. The following select runs ok, and produces data like LawrenceLustig:
SELECT (FirstName+LastName) AS Claimant FROM people
The following select, however, returns NULL or empty columns:
SELECT (FirstName+' '+LastName) AS Claimant FROM people.
CommentsProblem was in the expression evaluation engine.
ResolutionFixed Problem on 2/3/1999 in version 1.10 build 1