How to do string manipulation in SQL Query

Help Activities
, ,
1

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

2

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.

Regards,
NaNi

3

Hi Nani,

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

this is giving the result as excepted.
Thanks,

4

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