- (minus) character not showing in the columns aliases

As simple as the title…

Here it doesn’t show the character:

The query:

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

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)

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

1 Like