SQL Server - Convert LASTNAME, FIRSTNAME to camel case Firstname Lastname
<p>Hi as it states in the title i have names in the format LASTNAME, FIRSTNAME and i wish to have the data in the format Firstname Lastname.  This is going to be used in a OLE DB SOURCE query in SSIS so do not want it in a function.  How can this be done? </p>