Just in case it wasn't clear from Chuck's post, the SUBSTR function
works slightly differently than the SUBSTRING function; it's not just an
abbreviation of SUBSTRING. From the v5r3 documentation:
"A substring of expression is zero or more contiguous characters of
expression. If expression is a graphic string, a character is a DBCS,
UTF-16, or UCS-2 character. If expression is a character string and the
function is SUBSTRING, a character is a character that may consist of
one or more bytes. If expression is a character string and the function
is SUBSTR, a character is a byte.54 If expression is a binary string, a
character is a byte."
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
