Re: SubString SQL

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

yup...

 substr( digits ( <numeric_expression) , from, to)

be careful with the digits function... it returns strings of specific sizes
based on the parameter type... no sign or decimal point is included... it's
just digits.

If it fits in 5 or less, the length is 5 characters, if it fits in 10 or
less it is 10 characters (integer types) for larger integers it is 19.

If the number has decimals, then the length is the total length of the
number. ie. for a packed decimal (6,2) the string length is 6 and again, no
decimal point or sign is included.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"Those who would give up essential Liberty,
  to purchase a little temporary Safety,
  deserve neither Liberty nor Safety."

     - The Papers of Ben Franklin

-----Original Message-----
From: jacosta@idssinfo.com <jacosta@idssinfo.com>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Friday, December 08, 2000 9:29 AM
Subject: SubString SQL


>HI All,
>
>Does anyone know how to substring a numeric field or a date field in SQL?
>I am trying to use century and year to order by, on that same SQL
>statement.

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---