How to manipulate a string field in a SQL statement ?

[TheBionicOrange]

OK found it.

I used :

SELECT     SUBSTRING(Audit_Date, 7, 2) + '/' + SUBSTRING(Audit_Date, 5, 2) + '/' + SUBSTRING(Audit_Date, 1, 4) AS Expr1
FROM         Audit_Location_Summary