×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
TRANSLATE - Converts a Character to another Character
REPLACE - Replaces one or several characters with another or with several
other characters. It also allows to remove characters.
TRIM - Removes leading and/or trailing characters from a specific string
For more information please check the SQL Reference
http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/topic/db2/rbafz.pdf
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Tomasz Skorza
Gesendet: Wednesday, 28. October 2009 09:52
An: midrange-l@xxxxxxxxxxxx
Betreff: SQL function for clear text field
Hi
Do you know if in SQL on AS400 are some bult-in function which can
change some character to another - like dash "-" to space " ", and other
which can delete all space from text - so it will change "TOMASZ SKORZA"
to "TOMASZSKORZA"?
midrange.com
