Hello all,
Does anyone know why this would work in SQL 6.5 and not in SQL 2000??
Convert(float,Value.Value) > 80))
Value.Value is char 100
In the dB there are entries such as: 80.7 (total)
When I run this in SQL 6.5 is works fine and returns records.
When I run this in SQL2000 I get this error :
Error converting data type varchar to float.
I have tried CAST as well. I have tried to convert it to different data
types and they all die for various reasons.
Thank You in advance for your help
Cori
**************************************
Corina S. Moore @@
IMDC Software Developer (------)
301-286-6124 ( )
http://imdc.nasa.gov +=-=+
**************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
