SQL Request - UPPER function not working


Badge +9

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])


2 replies

Userlevel 5
Badge +14

can you try with column aliases?

select upper(stringname) AS StringName...

Badge +9

That worked!

Reply