Sybase Adaptive Server Anywhere - Page 327

Chapter 8 SQL Functions
309
♦ "TAN function" on page 370
♦ "TRUNCATE function" on page 372
♦ "TRUNCNUM function" on page 373
String functions
String functions perform conversion, extraction or manipulation operations
on strings, or return information about strings.
When working in a multi-byte character set, check carefully whether the
function being used returns information concerning characters or bytes.
The following string functions are available:
♦ "ASCII function " on page 314
♦ "BYTE_LENGTH function" on page 316
♦ "BYTE_SUBSTR function" on page 317
♦ "CHAR function" on page 319
♦ "CHARINDEX function" on page 319
♦ "CHAR_LENGTH function" on page 320
♦ "DIFFERENCE function" on page 333
♦ "INSERTSTR function" on page 341
♦ "LCASE function" on page 343
♦ "LEFT function" on page 343
♦ "LENGTH function" on page 344
♦ "LOCATE function" on page 345
♦ "LTRIM function" on page 347
♦ "PATINDEX function" on page 355
♦ "REPEAT function" on page 360
♦ "REPLACE function" on page 360
♦ "REPLICATE function" on page 361
♦ "RIGHT function" on page 362
♦ "RTRIM function" on page 363
♦ "SIMILAR function" on page 365
♦ "SOUNDEX function" on page 366
List of functions