select statement -> ignore upper / lower case

Dynamics 365 for Finance and Operations/AX Developer Forum
1

question:

how can i select regardless of upper and lower cases?

background:

i use the following select statement to filter a table:

select * from myTable where textField == myTextVariable;

issue:

sometimes the text field is uppercase and the text variable is lower case:

example:

textField: “some text”

myVariable: “SOME text”

(text Field == myVariable) = false

i tried:

select * from myTable where strUpr(textField) == strUpr(myTextVariable);

but this does not compile (AX2012)…

2

no, Ax 2012 is not case sensitive.

try this

static

select * from Table1 where Table1.Mystring == “JATAn”

;

{

print

table1.Mystring;

}

pause

;

if i give small latter jatan or capital letter jatan i will get TABLE data I E JATAN.

in table i stored JATAN IN CAPS.

voidJob1(Args _args){

table1 table1;

table1 table2;

;

3

thank you!

(there was something else wrong in my code and I just assumed that it was because of upper / lower case)