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: || === | + | ===Function: || (Concatenate) === |
'''Usage: 'Putting ' || A.COLUMN || ' and strings together' ''' | '''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. | This concatenates (puts together) column values and fixed character values. This has got to be one of the most useful functions. | ||
