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

Epicor ERP 10
1

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

BAQ
BAQ1628×712 257 KB

2

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

3

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

image
image1476×770 66.6 KB