BAQ how to set to filter only integer is shown from specific field

[andrew.phiss (andrew)]

hi all, please help how to set criteria of selecting only integer from specific field as below, Many thanks

[Zoher_Ali]

Hi @andrew.phiss, you can use IsNumeric(TranGLC.Key2) function of SQL.

[andrew.phiss (andrew)]

Thanks but it still doesnt work well, please help to check syntax as below and it prompt error of “Possible unauthorized query” thx