Mark In SQL 7 the syntax is
CONVERT(<datatype>[(length)], expression) ex. CONVERT(integer,#SomeVarCharVariable#) Brian Ferrigno -----Original Message----- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 1:00 PM To: CF-Talk Subject: quick SQL type question 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