Does Vertica have a mixed case string format function?

David_2

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?

[Deleted User]

Hi,

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.