|
|
ERR: Undefined function ‘SUBSTRING’ in expression.
Last post 10-05-2007, 12:52 PM by Robin Soto. 0 replies.
-
 10-05-2007, 12:52 PM |
-
Robin Soto
-
-
-
Joined on 07-27-2006
-
-
Posts 48
-
Points 0
-
|
ERR: Undefined function ‘SUBSTRING’ in expression.
| This article applies to: |
|
|
| Symptom |
|
If you try to parse the value in an imported file by using the SUBSTRING(ColumnName, start_number, num_chars) command for a column, you will received the following error message when the query is executed:
Undefined function 'SUBSTRING' in expression.
|
| Cause |
|
The Microsoft ODBC 2.0 Drivers no longer recognize the function called "SUBSTRING()". The name of the function has been changed to "MID()", which provides the same result as the previous SUBSTRING() function.
|
| Resolution |
|
For detailed information on this issue, please review the Microsoft Knowledge Base Article provided at the link below: http://support.microsoft.com/default.aspx/kb/135796 |
|
|
|
|
|