Re: SQL Casting/Exponential Notation

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Sigh...yes, of course it's an Excel issue. Sorry for the post...I was
making expectations that I shouldn't have made. Thanks for the help.

- Michael

On Thu, May 17, 2012 at 12:18 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:
> I'll bet dollars to doughnuts you guys are right. I just asked him to
> open the csv file in Note pad to see the actual data. I'll let you
> know. Thanks...
>
> On Thu, May 17, 2012 at 12:16 PM, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:
> > I'm with Chuck.  Though my inclination is to focus on the tail end of
> > the process first.  That is, my *first* question is:  What exactly is
> > showing you the value 5.00E+72?  999 times out of 1000 problems like
> > this are because the data is CSV and the application being used to
> > read it is Excel.  And when this is the case, no amount of quotation
> > marks will save you.  I can go into ways to remedy this, but first I'd
> > like to confirm that it's Excel.
> >
> > John
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.