Just always make sure to put an alias to any column you are customizing/formatting. It's like this:

SELECT ID,

FName+' '+MNane+' 'LName FullName, --on this Line, Name is the Alias

ISNULL(Address,...