getting syntex error for progress database

harshada · Post by **harshada** » Tue Sep 02, 2008 7:42 am

Hi
While using function like trim,substr in the sql for progress database it is working fine.But while using the same query in the ODBC stage and run it is giving syntex error.Any idea why?

Select substr(company_name,1,5) from company works fine in the progress database.
But the same query giving error in ODBC stage.

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 02, 2008 3:36 pm

ODBC has its own protocols and rules. The name of the function may be SUBSTRING rather than SUBSTR. You have to use the name that is specified in the ODBC grammar specification.