How to do something like:
Proper(“GALHANO.COM”) = “Galhano.com”
there’s no builtin function to do this but we combine CONCAT and SUBSTRING:
CONCAT(UCASE(SUBSTRING(`fieldName`, 1, 1)),LOWER(SUBSTRING(`fieldName`, 2)))
How to do something like:
Proper(“GALHANO.COM”) = “Galhano.com”
there’s no builtin function to do this but we combine CONCAT and SUBSTRING:
CONCAT(UCASE(SUBSTRING(`fieldName`, 1, 1)),LOWER(SUBSTRING(`fieldName`, 2)))
Home