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