Sybase String Functions

String functions are used different operations on character strings or expressions.

Syntax for String functions:

select function_name(arguments)

Example:

Sybase String Functions

Function Name Description
ascii To get ascii code for first character in expression
char Converts single byte into character value.
charindex searches for expression
char_length Returns the length of text value
difference Returns differences soundex values
lower Converts uppercase to lowercase characters
upper Converts lowercase to uppercase
ltrim Removing leading blanks
rtrim Removing trailing blanks
reverse To return reverse of string or binary expression
right Returns right of part of character expression
soundex Returns four characters soundex code
space Returns number single byte spaces
str Returns character representation of floating values
stuff Delete length of characters
substring Returns sub characters of string expression
Powered by k2schools