DB Access and SUBSTRING

[Laurent from France]

I tried the following SQL Request:
"SELECT DISTINCT SUBSTRING(Designation, 7, 2) FROM MyTable WHERE ..."
I would retrieve a part of the designation field of my table.

I have this following error:
Warning: SQL error: [Microsoft][Pilote ODBC Microsoft Access 97] fonction 'SUBSTRING' not defined in expression in SQLExecDirect.

I also tried SUBSTRING(Designation FROM 7 FOR 2), or used SUBSTR instead SUBSTRING: Same error occurs.
It doesn't work.
Does someone already had this problem and found a solution to resolv?
Thanks for help.

[Laurent from France]

I finally found!
If someone has the same problem, try:
SELECT mid(Designation ,17 ,8) AS PartDesign FROM MyTable WHERE...

------------
Laurent from France at 9/21/01 5:56:50 AM

I tried the following SQL Request:
"SELECT DISTINCT SUBSTRING(Designation, 7, 2) FROM MyTable WHERE ..."
I would retrieve a part of the designation field of my table.

I have this following error:
Warning: SQL error: [Microsoft][Pilote ODBC Microsoft Access 97] fonction 'SUBSTRING' not defined in expression in SQLExecDirect.

I also tried SUBSTRING(Designation FROM 7 FOR 2), or used SUBSTR instead SUBSTRING: Same error occurs.
It doesn't work.
Does someone already had this problem and found a solution to resolv?
Thanks for help.