<div>
Worked like a charm. Thank you!
</div>


<div>
<div class="content wysiwyg-content">
I have one field that has 6 types of test in one field.<br />
<br />
1. HMM<br />
2. HTC<br />
3. TMMC North<br />
4. TMMC South<br />
5. TMMC TIER<br />
6. TMMC WEST.<br />
<br />
For all records that have TMMC * I would like the text to simply read &quot;TMMC&quot;.<br />
<br />
So how can I use an Update Query (SQL Statement) to convert all TMMC North,TMMC South, TMMC West, TMMC TIER to simply read &quot;TMMC'.
</div>
</div>


I have one field that has 6 types of test in one field.

1. HMM
2. HTC
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'.

Update SQL to remove all characters after Certain text

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.