I've used queries like this thousands of times without issue. I know the fields are good; if I take out " " then this code works fine:
Select P.PERSONFIRSTNAME || " " || P.PERSONLASTNAME as FullName from Person P
I've regularly added spaces or various punctuation in this way in many other contexts without issue. Any clue why this would suddenly start acting up?
Select P.PERSONFIRSTNAME || P.PERSONLASTNAME as FullName from Person P
From novice to tech pro — start learning today.