My DTS package has an SQL statement to select data from an Access database
table. Adding the substring to the SLQ causes "ADO error: ." to be
displayed. The SQL runs ok without the substring. I have tried putting the
substring inside a Cast statement and that did not work either.
DISTRICT_NUMBER is a Text column with a length of 5 in the Access database.
However, the content is numeric. I tried to CAST the column as CHAR 5 and
got the same error.
SELECT ? AS invt_fy, BU_ID, substring(DISTRICT_NUMBER,3,3) as
District_Number, DISTRICTNAME, MAX(OP_BEGIN_DATE) AS op_begin_date
FROM TACIRBaseSchoolData
WHERE (REGION_DESCRIPTION <> 'Scott Test')
GROUP BY 1, BU_ID, DISTRICT_NUMBER, DISTRICTNAME
Any suggestions?

Does MS Access have SUBSTRING()? I thought they had MID()



"TACIR" <TACIR (AT) discussions (DOT) microsoft.com> wrote