ROWIDTOCHAR()

From Lianjapedia
Revision as of 05:28, 15 June 2011 by Yvonnemilne (Talk)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to return a numeric as a ten character string with leading zeros


Syntax

ROWIDTOCHAR(<expN1>)


See Also

INT(), LPAD(), RPAD(), STR(), STRZERO(), TRANSFORM(), VAL()


Description

The ROWIDTOCHAR() function converts the numeric expression <expN1> to a right justified ten character string.


Example

? rowidtochar(1234)
0000000123


Products

Recital, Recital Server