Skip to main content
Nintex Community Menu Bar

SQL Request - UPPER function not working

  • March 9, 2018
  • 2 replies
  • 7 views

Forum|alt.badge.img+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

Forum|alt.badge.img+14
  • Scholar
  • March 9, 2018

can you try with column aliases?

select upper(stringname) AS StringName...


Forum|alt.badge.img+9
  • Author
  • March 12, 2018

That worked!