String Functions

String functions are used with STRING values and usually return a STRING value. Examples of string functions include left (), rtrim (), and replace ().

• int32()
  Scalar. Converts a given string into an integer.
• left()
  Scalar. Returns a specified number of characters from the beginning of a given string.
• length()
  Scalar. Returns the number of bytes of a given binary value, string, or multibyte string.
• like()
  Scalar. Determines whether a given string matches a specified pattern string.
• lower()
  Scalar. Returns a new string where all the characters of the given string are lowercase.
• ltrim()
  Scalar. Trims spaces from the left side of a string.
• patindex()
  Scalar. Determines the position of the nth occurrence of a pattern within a source string.
• real()
  Scalar. Converts a given string into a float.
• regexp_firstsearch()
  Scalar. Returns the first occurrence of a POSIX regular expression pattern found in a given string.
• regexp_replace()
  Scalar. Returns a given string with the first occurrence of a match for a POSIX regular expression pattern replaced with a second, specified string.
• regexp_search()
  Scalar. Determines whether or not a string contains a match for a POSIX regular expression pattern.
• replace()
  Scalar. Returns a new string where all the occurrences of the second string in the first string are replaced with the third string.
• right()
  Scalar. Returns the rightmost characters of a string.
• rtrim()
  Scalar. Trims spaces from the right of a string.
• substr()
  Scalar. Returns a substring of a given string, based on a start position and number of characters.
• trim()
  Scalar. Returns a given string after removing trailing and leading spaces.
• trunc()
  Scalar. Truncates the time portion of a date to 00:00:00 and returns the new date value.
• upper()
  Scalar. Returns a string where all the characters of a given string are uppercase.