RE: [sqr-users] How to format the enclosed items

[Bruce Kelling <Bruce_Kelling@advantechsolutions.com>]

Dates and text edits -

Insead of TO_CHAR(&PER.BIRTHDATE, 'YYYY-mm-dd') (ORACLE)
Use edit(&PER.BIRTHDATE, 'YYYY-mm-dd')  (SQR)

Trim spaces and pad spaces -

RPAD, LPAD, RTRIM, LTRIM are all the same in SQR and oracle.



Bruce


-----Original Message-----
From: m rapson [mailto:mrapson@hotmail.com] 
Sent: Thursday, August 21, 2003 10:24 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] How to format the enclosed items


I am using Oracle 9i database.  I have a few things I am not sure how to 
format or the syntax using an SQR.

Date - This is how it is written in ORACLE but not sure how to translate to 
SQR
TO_CHAR(&PER.BIRTHDATE, 'YYYY-mm-dd')

Trim spaces and pad spaces -

RPAD(LTRIM(&PER.NAME), 26, ' ')
RPAD(&LOC.ADDRESS1, 35, ' ')

Thanks for your help in advance!!!

Melissa

_________________________________________________________________
Chat privately with Bon Jovi, Seal, Bow Wow, or Mary J Blige using MSN 
Messenger! http://www5.msnmessenger-download.com/imastar/default.aspx

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users