How to do string manipulation in SQL Query

While using the Excel as a Database how we can achieve the String manipulation in SQL Query (Run command/Run Query)

Hey @hrishikesh_mali ,

Welcome to community.

You can use normal sql queries to do string manupulation.

Try this:

SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM Employee.


Hi Nani,

“Update [Sheetname$] set [column name]=Replace([Columnname],‘string1’,‘string2’)”

this is giving the result as excepted.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.