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