Datawarehouse Architect

  Functions of ASCII in OBIEE ASCII Converts a single character string to its corresponding ASCII code, between 0 and 255. If the character expression evaluates to more than one character, the ASCII code corresponding to the first character in the expression is returned. Syntax Ascii(strExpr) Where: Expr Any expression that evaluates to a character string. Practical Usage in Answers Using the Paint Business Area SELECT Markets.Region saw_0, Ascii(Markets.Region) saw_1, Ascii('C') saw_2, Ascii('a') saw_3 FROM Paint ORDER BY saw_0, saw_1, saw_2, saw_3

  OBIEE String Functions String functions perform various manipulations on character strings. Place character strings within single quotes. Functions ASCII Bit_Length   Char Char_Length Concat Insert Left Length Locate LocateN Lower Octet_Length Position Repeat Replace Right Space Substring TrimBoth TrimLeading TrimTrailing Upper