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