Please help me with a SQL statement that will remove "Atten" from the Attent field that contains rows with:
Atten Jane Doe
Attention Jan Doe
Select * from Leas where Attent like 'Atten%'
will return the appropriate rows. What addtional syntax will remove only the Atten and Attention and leave the names in the Attent field?