Insert info from table to appear after text

CASE WHEN system_type__c IS NOT NULL 
THEN 'Please setup a new system [' + system_type__c + '] for new employee ' + 'New_Employee_Name__c' ELSE '' END AS SystemTypeDesc, 

My code isn't working correctly. I want the text that is inpu开发者_开发知识库tted into the New_Employee_Name__c field to be added after 'Please setup a new system' text

I got the system_type__c field to input correctly.

Remove the quotes from New_Employee_Name__c. The single quotes signify a literal string.

CASE WHEN system_type__c IS NOT NULL THEN 
    'Please setup a new system [' + 
    system_type__c + 
    '] for new employee ' + 
    New_Employee_Name__c 
ELSE '' 
END AS SystemTypeDesc, 

Take the quotes away from around 'New_Employee_Name__c' ?

Take the quotes off the field name.

CASE WHEN system_type__c IS NOT NULL THEN 'Please setup a new system [' + system_type__c + '] for new employee ' + New_Employee_Name__c ELSE '' END AS SystemTypeDesc,

take the quotes off the field name:

CASE WHEN system_type__c IS NOT NULL 
    THEN 'Please setup a new system [' + system_type__c + '] for new employee ' + New_Employee_Name__c ELSE '' END AS SystemTypeDesc,