find & replace tool in LibreOffice Base

Is there replace option in Base?
Simply I need some repeating text (letter) in the field (column) to replace with another, so how to do that?
Thank you.


Other than maybe some SQL, there is no replace function in Base as you request. However the answer by @librebel in this post, REGEX support in Base queries and in Basic search and replace string functions may be of some help.