Skip to main content
Question

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$$]

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$$]

    2 replies

    Tamil Arasu10
    Most Valuable Pathfinder
    Forum|alt.badge.img+7

    Hi @Karthikeyan Palani​ ,

     

    Yes, Supported.

     

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

    FROM Customers;

     

     

    _Tamil_

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

    Terms & ConditionsAccessibility statement