instr (identifier) is not valid input at this position" when Creating Procedure

[jeffrey alexander]

Been moving my work from one server over to another and having a bit of an issue

The following statement works fine in a procedure on my old server as well as when I run it as a query

update table
set symbol = left(symbol,instr(symbol," XY")-1)
where
instr(symbol," XY")>0

However, when I try to create a procedure with it in the new mysql server, I get the following error:

"instr (identifier) is not valid input at this position"

Pointing at the Instr and it won't let me continue

Any help on why this could be happening would be much appreciated

Thanks