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 Job Scheduler
- Recover or reset QSECOFR passwords
- Make a Home made, open source mp3 Player
- UDATE and *DATE in AS400 RPG
- Sending and receiving email on i5/os - QtmmSendMail
- A free fully functional database is yours with Microsoft's SQL Server Express
- AS400 API - QCMDEXC - Execute Command
- API Example - Deleting Old Spooled Files
- AS400 Jobs: Do you have a job at the moment?
- 3 fires up high-speed Super 3G network, News at CNET.co.uk
No comments:
Post a Comment