SQL Request - UPPER function not working

[furstlars]

My dropdown list won't display values if the UPPER function is included. The test run in the control settings work. Why?!

i.e. SELECT UPPER([StringName])

[emha · Accepted solution]

can you try with column aliases?

select upper(stringname) AS StringName...

[furstlars]

That worked!