Help! I'm using MS SQL Views

[john_oc]

And I need help with a query. I have a field that I want to test if it has ".bat" at the end if so I want to replace this with another field. I tried using the "replace"
but it replaces only the ".bat" portion of the field. Any idea's?

Thanks

[Phil1234]

So you want to replace the whole entire field with another field where the field has .bat?
How about
update Table1
set field1 = field2 where field1 like '%.bat'