Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions

Transformation Language Reference

Transformation Language Reference

Character Functions

Character Functions

The transformation language includes the following character functions:
  • ASCII
  • CHR
  • CHRCODE
  • CONCAT
  • INITCAP
  • INSTR
  • LENGTH
  • LOWER
  • LPAD
  • LTRIM
  • METAPHONE
  • REPLACECHR
  • REPLACESTR
  • RPAD
  • RTRIM
  • SOUNDEX
  • SUBSTR
  • UPPER
The character functions MAX, MIN, LOWER, UPPER, and INITCAP use the code page of the
Data Integration Service
to evaluate character data.

0 COMMENTS

We’d like to hear from you!