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

[leoliang]

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)

 

[HelloMike]

Try using the INSTR function. Something like this might do the trick:

SELECT id, desc FROM item WHERE INSTR(desc,'sss') > 0.

 

[harebrain]

Or you could use wildcards:

SELECT id, desc FROM item WHERE desc LIKE '__sss%'.

 

[tarapore]

Try the SUBSTR function:

select id, desc from item where substr(desc,3,5) = 'sss'

Ronnie.