Upper(var) then use to search blaze table

Questions and Help
1

ICAO IN: {formtext: name=icao_in}
{dbselect: SELECT ICAO, ap_name, tower, class FROM ZLA_AP WHERE ICAO = @icao_in; space=7gYWcz1kN4GysgT1nyYxcI; menu=no}
NAME: {=proper(ap_name); trim=left}
Has Tower: {=proper(tower)}
CLASS: {=upper(class)}

(The DB field "ICAO" is in all UPPERCASE)

This works fine if the user inputs all UPPERCASE, however, does not when mixed or lowercase.

How do I convert the icao_in field to uppercase for searching?

2

Hi @Timothy_Treaster,

You can create another variable icao=upper(icao_in) and use that in your dbselect query.

ICAO IN: {formtext: name=icao_in}{icao=upper(icao_in)}
{dbselect: SELECT ICAO, ap_name, tower, class FROM ZLA_AP WHERE ICAO = @icao; space=7gYWcz1kN4GysgT1nyYxcI; menu=no}
NAME: {=proper(ap_name); trim=left}
Has Tower: {=proper(tower)}
CLASS: {=upper(class)}

1 Like