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
- as400 Iseries Tips
- Common Gateway Interface (CGI) on the as400 / iSeries
- AS400 Job Scheduler
- Why Crunch Mode (Long Hours) Doesn't Work
- Using as400 QRCVDTAQ api to retrieve a message / entry from a dataqueue
- as400 iSeries NetServer Disabled user profiles
- AS400 APIs
- Configuring Tomcat5 and Apache2 with Virtual Hosts using mod_jk
- Adobe Flex 2.0 Beta
- EclipseZone - Clean Up Warnings with the 'restriction' Suppression Flag
No comments:
Post a Comment