SQL find text within lines and change it

Question

Hello! I do not seem to get how to make it. I have an Excel table, a glossary to be more specific, and i found out that several lines contain wrong terms. For example, the term is "dog" but in the glossary there is a misspell and each line has "gdo" instead of dog. The trouble is that there are many lines that have some attributes for this "dog", and the lines look like "Black gdo", "Gdo house" and so on. So i need to change only the noun while leaving the other words in the line intact. How can I correct by means of an SQL query (namely be means of Microsoft Query)?

Answer 1

See if it in Excel sheet then you can't update by using SQL query. But if your Excel data is coming from databases so you can simply write a update query which will replace all wrong word with correct word in database.

But if it is not coming from database means it's a simple Excel Sheet then you can replace by using replace option which will be available in Excel.

Answer 2

A J thank you so much, that is strange then. You see I was given this task in Excel table and the instruction is pretty clear that I have to use SQL Query. I Wonder what will the query look like anyway.