SQL recursive REPLACE command: "REPLACE(SourceString, FindString, NewString) where SourceString is the string to search, FindSting is the string you want to replace and NewString is the string you want to put in the place of FindString.
This function is recursive so it will replace all occurrences of FindString within SourceString. The function will accommodate any string size up to 2000 characters. "
Monday, January 31, 2005
Subscribe to:
Post Comments (Atom)
Popular Posts
- Using QCLRDTAQ to clear data queues in CL and RPG
- AS400 Job Scheduler
- UDATE and *DATE in AS400 RPG
- Creating an as400 Query
- Adobe Flex 2.0 Beta
- ibm as400 manuals v5r4
- IBM WebSphere Developer Technical Journal: Maintain continuous availability while updating WebSphere Application Server enterprise applications
- Recover or reset QSECOFR passwords
- Encrypt Data on as400 (QC3ENCDT, Qc3EncryptData)
- Privacy Policy
No comments:
Post a Comment