I have almost solved this but I am missing something. The whole Forest because of the Trees thing.
I need to remove 1 final - from my string. Here is my sql.
I need to remove 1 final - from my string. Here is my sql.
SELECT tblmaintenance.sernu, Right([sernu],10) AS m10digit, InStr([m10digit],"-") AS [Space]
FROM tblmaintenance;