Does Vertica have a mixed case string format function?
Vertica has functions to format text in upper and lower case, such as UPPER() and LOWER().
But I dont see any function for setting text to mixed case, so I can get "Visa", not "VISA" or "visa".
Is mixed case formatting possible in the select line?
But I dont see any function for setting text to mixed case, so I can get "Visa", not "VISA" or "visa".
Is mixed case formatting possible in the select line?
0
Comments
I think the INITCAP and INITCAPB functions should cover this.
vap=> select 'visa';
?column?
----------
visa
(1 row)
vap=> select initcap('visa');
initcap
---------
Visa
(1 row)
They can be found in the SQL Reference, SQL Functions, String Functions section of the docs.