I am running a SELECT statement and am getting the following error:Error converting data type varchar to float.A lot of the fields are the float datatype and I am trying to add characters between some of them. Here is the code:SELECT tblTank_Information.Tank_Number, tblTank_Information.SAPMaterialCode, tblProduct_Code.Product_Code, (tblDaily_Gauge_Data.Current_Gauge_Feet + CHAR(39) + CHAR(32) + tblDaily_Gauge_Data.Current_Gauge_Inches + CHAR(45) + tblDaily_Gauge_Data.Current_Gauge_Fraction + CHAR(34)) AS Gauge, (tblTank_Information.Minimum_Gauge_Ft + CHAR(39) + CHAR(32) + tblTank_Information.Minimum_Gauge_In + CHAR(34)) AS Minimum, (tblTank_Information.Maximum_Gauge_Ft + CHAR(39) + CHAR(32) + tblTank_Information.Maximum_Gauge_In + CHAR(34)) AS Maximum, (CHAR(40) + tblTank_Information.Minimum_Temp_F + CHAR(45) + tblTank_information.Maximum_Temp_F + CHAR(41)) AS TempRange, tblDaily_Gauge_Data.Current_Gauge_Date FROM tblTank_Information, tblDaily_Gauge_Data, tblProduct_Code WHERE tblTank_Information.Gauging_Area_Code = '17'
What could I do to fix this? Do I have to convert each type to char??
Data type error in SELECT
Posted - 2012-01-17 : 13:55:37
