Hi there!

How can I use in a Script the following SQL statement?

substr(a.t$erro,1,3)='SLS'

Is there a left function?

Thank you all!!!

Hi mrreds

Did you try "Like", "Alike" predicate?

For Details go through following link.

http://www.baanboard.com/baanboard/showthread.php?t=48942&highlight=Alike

Thanks and Regards
MilindV

If the position of constants is fixed , u may clause like ttyp(2;3) = "SLS" in baan sql where clause (for 3 characters from 2nd being equal to 'SLS') . Like operator will also work in baan sql .