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
- Yahoo! Mail: Revenge of the Oddpost
- Linux Forum: Apache, Webmin and Mandrake - Linux Operating System Help
- Free AS400 & iSeries Software Tools & Utilities Downloads
- The Laughing Boardroom video...a real world example!
- IBM eServer iSeries - The Laughing Boardroom
- UDATE and *DATE in AS400 RPG
- Sneaky Uses For Everyday Things
- What is QZHQSSRV job?
- Creating an as400 Query
- Difference between SFLINZ and SFLCLR keyword?
No comments:
Post a Comment