Michael Pizzo (Inactive) added a comment - 27/Oct/22 4:18 PM - edited Note that SQL seems to require something like a subselect in order to reference a previously computed value.  i.e., given a "users" table with firstName, lastName, and prefix columns, the following does not work: select concat(firstName,lastName) as fullName, concat(prefix, fullName) as name from users  though you could do something like: select concat(prefix, fullName) as name from (select prefix, concat(firstName, lastName) as fullName from users) as U1

Michael Pizzo (Inactive) added a comment - 27/Oct/22 4:46 PM Similarly, LINQ does not support the following syntax: users.Select(u => new { fullName = u.firstName + u.lastName, name = u.prefix + fullName }); (the use of fullName in name=u.prefix + fullName is not valid) you would instead need to do:   users.Select(u => new { fullName = u.firstName + u.lastName, prefix = u.prefix }).Select(u2 => new { name = u2.prefix + u2.fullName });