Category: ASE: Functions: String Functions

String Functions

String functions are functions for querying and displaying string relevant data in ASE®.

String functions can be nested and used in the where clause of a select query or wherever so-called expressions are allowed. In order to use constants in a string function, it is recommended to use single or double quotes. The names of string functions are not reserved words.

String functions recognise parameters, which can be automatically converted into the required datatype using implicit conversion.

List of ASE String Functions

ASE® provides a number of string functions:

• ascii()
• char()
• charindex()
• char_length()
• compare()
• difference()
• lower()
• ltrim()
• patindex()
• replicate()
• reverse()
• right()
• rtrim()
• sortkey()
• soundex()
• space()
• srt()
• stuff()
• substring()
• to_unichar()
• uhighsurr(),
  
• ulowsurr(),
  
• upper()
• uscalar()

See also:

ASE T-SQL - Aggregate Functions,
ascii(),
char(),
char(n),
charindex(),
char_length(),
compare(),
difference(),
lower(),
ltrim(),
patindex(),
replicate(),
reverse(),
right(),
rtrim(),
sortkey(),
soundex(),
space(),
str(),
stuff(),
substring(),
to_unichar(),
uhighsurr(),
ulowsurr(),
upper(),
uscalar().