SqlExpression INITCAP

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Input 4 Output 5 Example

Syntax

INITCAP( source_string )

Purpose

Capitalizes the first character and lowercases the rest of the characters for all words within a string

Input

• source_string [VARCHAR] - string to convert

Output

• [VARCHAR] - source_string which has been converted so all words have the first character capitalized and subsequent characters lowercased. Returns null with a null input and empty string for empty string

Example

Function	Result
INITCAP( 'THis %is% a sTrINg8 34 g-G' )	This %is% A String8 34 G-g
INITCAP( )

---

Return to Built in Function details