How Can I Make Mid(string,3,5) Work

[leo_unsw]

HI
I AM RUNNING A SQL STATEMENT SHOWN BELOW, BUT MY DRIVER DOESNT KNOW HOW TO DEAL WITH IT? ANYONE KNOW HOW I CAN SOLVE THIS PROLEM?
THANKS A LOT

sql is :
select id, desc from item where mid(desc,3) = 'sss'

my driver is:
merant 3.70 32-bit progress

the error message is:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'[MERANT][ODBC PROGRESS driver][PROGRESS]** Unable to understand after -- "item where mid". (247)

 

[jonasj]

Typo?

HI

sql is :
select id, desc from item where mid(desc,3) = 'sss'

So, did You write mid(desc,3) in Your code, or mid(desc,3,5)?