Using Expressions in PS Query
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Using Expressions in PS Query
| Line 4: | Line 4: | ||
== Oracle SQL Functions in PeopleSoft Query == | == Oracle SQL Functions in PeopleSoft Query == | ||
| + | ===Function: || === | ||
| + | '''Usage: 'Putting ' || A.COLUMN || ' and strings together' ''' | ||
| + | This concatenates (puts together) column values and fixed character values. This has got to be one of the most useful functions. | ||
| + | |||
| + | '''Examples''' | ||
| + | :'PS_' || A.RECNAME - Gives the standard table name from the record name. | ||
| + | |||
| + | ===Function: Substr === | ||
| + | '''Usage: substr(A.DESCR,start_position,number_of_characters) ''' | ||
| + | '''Usage: substr(A.DESCR,start_position) ''' | ||
| + | '''Usage: substr(A.DESCR,-start_position,number_of_characters) ''' | ||
| + | This extracts a part of a text column. | ||
| + | |||
| + | '''Examples''' | ||
| + | :Substr(A.DESCR,3) - The description without the first three characters | ||
