Re: testing a char field for numeri chars in SQL

Kathleen,

In a message dated 98-04-09 20:05:45 EDT, you write:

> You may not be out of luck.  After all, this is the AS/400 we are talking
>  about, the _Ultimate DataBase Machine_! :^)
>  
>  Anything you define in a physical can be redefined in a logical.  If you
>  create a new logical over this physical, you can create these 3 positions
>  as a separate field, or even 3 separate fields if you wish.  I once had to
>  do this over a 6 long packed field which contained a date in the format
>  MMDDYY.  It's been a very long time, but, based on memory...
>  
>  Give your new logical a new record format name that is different from the
>  physical file's record format.  Basically you are creating a new record
>  format definition for this file.
<<snip>>

_BRAVO_ (and I don't hand out the "bravo's" lightly) Kathleen!  While the rest
of us (myself _DEFINITELY_ included) were spinning our wheels trying to come
up with an SQL solution for this, _YOU_ came up with a simple, yet elegant,
DDS solution to the problem.  Had to whack myself in the forehead with open
palm and scream "Dooohhhh"!  (perhaps "Duhhhh!" for those that aren't
inundated with billions of adverts for "The Simpsons").

Thanks!

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@aol.com

"There are those that watch things happen, those that make things happen, and
those that wonder what happened." -- Anonymous
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---