Update SQL to remove all characters after Certain text
Posted on 2015-02-23
I have one field that has 6 types of test in one field.
3. TMMC North
4. TMMC South
5. TMMC TIER
6. TMMC WEST.
For all records that have TMMC * I would like the text to simply read "TMMC".
So how can I use an Update Query (SQL Statement) to convert all TMMC North,TMMC South, TMMC West, TMMC TIER to simply read "TMMC'.