l have a column named Field which had prefixes like T01. , T02. etc. l would like to use the Replace function so l can end up with the field name minus the T01. etc

ie
T01.DFTES should be DFTES but
BALANCE should remain as BALANCE because it does not have the prefixes.

FIELD
=========
T01.DFTES
T02.IDBNGCDS
T03.TRDFRED
T04.SGR311
T05.GRP311
BALANCE PVA311+BAL320
T02.VFGTY
T04.LRD311
TOTAL
SUBSCRIBER


l'm currently using this query :-

SELECT
Substring(Field,5,10) AS Field
From EXACTUS_Fields
WHERE Substring(Field,1,4) like '%.%'

UNION ALL

SELECT
Field
FROM EXACTUS_Fields
WHERE Substring(Field,1,4) Not like '%.%'


Whats the best way of updating the table? Or rather what function can l use.