NBR2STR() Short: ------ NBR2STR() Correctly orders numerics where negative Returns: -------- String Syntax: ------- NBR2STR(nNumber) Description: ------------ Ensure numeric fields are correctly ordered when converting to type character and when taking negatives into account. This is done by attaching CR, DB or CZ to the end of the number to overcome the placement of (-+) in the ASCII scale. Examples: --------- index on LASTNAME+NBR2STR(amount_due) to NEWINDEX Source: ------- S_NBR2ST.PRG
Pingback: SP Conversion Functions | Viva Clipper !
Pingback: SP Functions | Viva Clipper !