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$$]
Page 1 / 1
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.