Use instr/position/locate in BAQ

Epicor ERP 10
,
1

Hi all,

is it possible to use any of these functions in BAQ?

They should give the same result in SQL. Is there a similar function in BAQ that does this, i.e. returns the position of the first occurrence of a string in another string?

Thanks for your help.

Regards
Hymal7

2

Those are commands for MySQL.

Look for SQL Server ones.
CHARINDEX

I did test this and it worked.

2 Likes