Can anyone tell me the correct syntax for the type convert in a sql statement?
I need to insert data from one field that's type is varchar into a numeric field. The data in the varchar field are numbers. I get "Error converting data type varchar to numeric" when running: INSERT INTO table1 (AcquisitionNumber) SELECT Acquisition FROM table2 I saw something at devcon that there was a type convert in SQL INSERT INTO table1 (convert2numeric(AcquisitionNumber)) SELECT Acquisition FROM table2 Any one know more about this? Thanks Mark W. Breneman -Macromedia Certified ColdFusion 5 Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists