Does Crystal Reports 9 have an 'rpad' function?

[alarge23]

I am trying to create a selection formula and I need a function similar to the SQL function: rpad. Does Crystal Reports have this function?

 

[pgtek]

hi
rpad is an oracle function
and yes you can used it in crystal SQL expression

cheers

pg

pgtek

 

[IdoMillet]

If what you are looking for is a Crystal formula, here's an expression you can use (assuming total length is 10 and padding is with zeros:

LEFT(TRIM(MyField)+ ReplicateString("0", 10),10)

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com