>- see footer for list info -< because they are stored in a varchar column and i want to add them up ..
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Robertson-Ravo, > Neil (RX) > Sent: 03 June 2005 10:00 > To: Coldfusion Development > Subject: RE: [CF-Dev] off topic .. sql ... > > > >- see footer for list info -< > 10.00 and 5.00 are decimals why do you need to CAST them?....... > > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jenny Gavin-Wear > Sent: 02 June 2005 23:42 > To: Coldfusion Development > Subject: [CF-Dev] off topic .. sql ... > > >- see footer for list info -< > > > hi .. scratching my head ... to convert a string into a value in ms sql. > > have been trying cast but sql doesn't like my syntax .. > > what i want to do is ... cast(column_name as decimal) as a new query > column.. > > example column_name values are ... "10.00", "5.00" ... > > any ideas please? > > Jenny > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer > your help -< > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive > use of the > intended recipient(s). If you are not the intended recipient(s) > please note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the > sender or call > our switchboard on +44 (0) 20 89107910. The opinions expressed > within this > communication are not necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.com > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving > lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer > your help -< > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
