ExecuteSQL does not get information from a calculation field?

Discussion created by user17750 on May 29, 2013
Latest reply on May 29, 2013 by Mike_Mitchell

ExecuteSQL (


"SELECT Full_Name_c From Test" ; "" ; ""




I have a field called Full_Name_c which is a calulation field containing First_Name &" "&Last_Name


But the SELECT statment pulls no data.


If I replace the Full_Name_c in the above SELECT statement with First_Name it works.


Does the SELECT statement not work with calculation fields???


Thanks for your thoughts and help on this one!!