STRZERO()

From Recital Documentation Wiki
Revision as of 15:20, 20 March 2009 by Yvonnemilne (Talk | contribs)

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

STRZERO()

Class

Expressions And Type Conversion


Purpose

Function to perform numeric to string conversion


Syntax

STRZERO(<expN1>, <expN2> [,<expN3>])


See Also

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


Description

The STRZERO() function converts the numeric expression <expN1> to a right justified character string of width <expN2>, rounded to <expN3> decimal places. If <expN2> is not specified, then a string of 10 characters is returned. If <expN3> is not specified, then <expN1> is treated as an integer. The STRZERO() function operates in the same way as the STR() function except that zeroes are placed at the start of the string instead of spaces. This function is very useful for storing numeric numbers in character fields so that they appear in the expected sequential order.


Example

? strzero(1234,8)
00001234


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer