Skip to main content
whether the A360 Database command support the Query which applies substring to any column(establishing excel as DB) Example SELECT SUBSTRING([column],1,5) FROM [Sheet1$$]

Hi @Karthikeyan Palani​ ,

 

Yes, Supported.

 

Example: SELECT SUBSTRING(CustomerName, 1, 5) AS ExtractString

FROM Customers;

 

 


i tried the same established excel as database and called the substring query it is taking indefinite time to execute the query


Reply