case insensitive like in a select/exec statement

Community Support
1

How do you do a case insensitive like in a select/exec statement

2

Hi,

A simple solution is to use the upper/lower functions on the columns you are selecting from:

q)tab:(n:AB`C;v:1 2 3)

q)tab

n v

A 1

B 2

C 3

q)select from tab where lower[n]=`a

n v

A 1

Regards,

Thomas Smyth

Developer - AquaQ Analytics