Hi Ian,
Thanks for the guidance, I have tried the following, but get an error:
Incorrect syntax near the keyword 'AS'.
SELECT commentsTbl.ID, commentsTbl.commID, commentsTbl.commArea, commentsTbl.isPublishedComm,
CASE
WHEN commentsTbl.isPublishedComm = 'False' THEN
userTbl.userFirst + '...