SQL query error

[edwardp]

I have this SQL query

SELECT CUST_ORDER_LINE.CUST_ORDER_ID, CUST_ORDER_LINE.PART_ID, PART.DESCRIPTION
FROM CUST_ORDER_LINE, PART
WHERE CUST_ORDER_LINE.PART_ID = PART.ID
HAVING CUST_ORDER_LINE.PART_ID like '[0-9][0-9][a-z][a-z][a-z][0-9][0-9][0-9][0-9]' AND CUST_ORDER_LINE.CUST_ORDER_ID like 'SO-%'
ORDER BY mid(CUST_ORDER_LINE.CUST_ORDER_ID, 4, 5) asc;

I am connecting to MS SQL SERVER database.

I get the following message,

Warning: MS SQL message: 'mid' is not a recognized function name. (severity 15) in c:\apache\htdocs\project2\test2.php on line 10

I have used the mid function before but that was on a different database

Can anyone point me right??

Regards

[Lars_Berg]

SELECT CUST_ORDER_LINE.CUST_ORDER_ID, CUST_ORDER_LINE.PART_ID, PART.DESCRIPTION
FROM CUST_ORDER_LINE, PART
WHERE CUST_ORDER_LINE.PART_ID = PART.ID
and CUST_ORDER_LINE.PART_ID like '[0-9][0-9][a-z][a-z][a-z][0-9][0-9][0-9][0-9]' AND CUST_ORDER_LINE.CUST_ORDER_ID like 'SO-%'
ORDER BY substring(CUST_ORDER_LINE.CUST_ORDER_ID, 4, 5) asc