Hello Again Experts,
I've got a query below, however the JBCAFirstName column is a new addition, and in some instances there will be no value, I've tried to overcome this by LTRIM to remove spaces, however when I run the query against a record that i know has no value in the JBCAFirstName column but a value in the JBACANamecolumn, it returns nothing for the Name column?
Anyway around this?
SELECT JBACAID, JBACAUsername, LTRIM( Lower(JBCAFirstName +' '+ JBACAName)) As Name
WHERE JBACAID = MMColParam