- (minus) character not showing in the columns aliases


#1

As simple as the title…

Here it doesn’t show the character:
image

The query:
image

If I switch to a ‘+’ (plus) character, it will work just fine. I’m using native query. Any thoughts?


#2

It could perhaps be the Friendly Table and Field Names feature biting you – so, not so friendly here (aka a small rare bug). As a workaround you can either try to turn that off or use another similar char with a different code like for example: – (n-dash)


#3

Hmmmm, sneaky n-dash did the job for me, thanks!