Feature request for the functions CHARINDEX and LENGTH

[tikomir]

It seems that only a few String functions have been supported. For example, there are no LENGTH and CHARINDEX functions which I consider essential. Here s an example:

INSERT` INTO Customer (FirstName, LastName, City, Country, Phone)
SELECT LEFT(ContactName, CHARINDEX(' ', ContactName) - 1),
SUBSTRING(ContactName, CHARINDEX(' ', ContactName) + 1, 100),
City, Country, Phone
FROM Supplier
WHERE CompanyName = 'Bigfoot Supplies';

Customer.insert(
     Supplier.slice(
                Supplier.contactName.substring(0, 1), // function CHARINDEX needed here
                Supplier.contactName.substring(0, 2), // function CHARINDEX needed here
                Supplier.city,
                Supplier.country,
                Supplier.phone)
            .select { Supplier.companyName eq "Bigfoot Supplies" },
      columns = listOf(Customer.firstName, Customer.lastName, Customer.city, Customer.country, Customer.phone)
)

As you can see, the column Supplier.ContactName contains name and surname as one string and I want to split them. Is there any way I can do it without CHARINDEX function?

[fedache]

@Tapac is this issue still needed ?