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?
Does Vertica have a mixed case string format function?
+2Hi,
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.
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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
