SQL Character Functions

Topics:

• CHAR_LENGTH: Finding the Length of a Character String
• CONCAT: Concatenating Two Character Strings
• DIGITS: Converting a Numeric Value to a Character String
• EDIT: Editing a Value According to a Format (SQL)
• LCASE: Converting a Character String to Lowercase
• LTRIM: Removing Leading Spaces
• POSITION: Finding the Position of a Substring
• RTRIM: Removing Trailing Spaces
• SUBSTR: Extracting a Substring From a String Value (SQL)
• TRIM: Removing Leading or Trailing Characters (SQL)
• UCASE: Converting a Character String to Uppercase
• VARGRAPHIC: Converting to Double-byte Character Data