Cast into Numeric
-
Hi, Problem with converting varchar into Numeric select DEFINITION_DETAIL_DATA.SMID, Cast(Data_Value as Numeric)as Val from DEFINITION_DETAIL_DATA inner join DEFINITION_MST on DEFINITION_MST.SMID = DEFINITION_DETAIL_DATA.SMID Where DEFINITION_MST.MPID = 176 and Convert(Numeric,Data_Value) > 10000 Value without where condition shows like. 1 2500 2 3500 3 5000 4 10000 5 15000 6 20000 but when i add Convert(Numeric,Data_Value) > 10000 in query then its give me an error. Error converting data type varchar to numeric.
kiran banker
-
Hi, Problem with converting varchar into Numeric select DEFINITION_DETAIL_DATA.SMID, Cast(Data_Value as Numeric)as Val from DEFINITION_DETAIL_DATA inner join DEFINITION_MST on DEFINITION_MST.SMID = DEFINITION_DETAIL_DATA.SMID Where DEFINITION_MST.MPID = 176 and Convert(Numeric,Data_Value) > 10000 Value without where condition shows like. 1 2500 2 3500 3 5000 4 10000 5 15000 6 20000 but when i add Convert(Numeric,Data_Value) > 10000 in query then its give me an error. Error converting data type varchar to numeric.
kiran banker
-
plz try this select DEFINITION_DETAIL_DATA.SMID, Cast(Data_Value as Numeric)as Val from DEFINITION_DETAIL_DATA inner join DEFINITION_MST on DEFINITION_MST.SMID = DEFINITION_DETAIL_DATA.SMID Where DEFINITION_MST.MPID = 176 and val > 10000
giving an error invalid column namd
kiran banker
-
plz try this select DEFINITION_DETAIL_DATA.SMID, Cast(Data_Value as Numeric)as Val from DEFINITION_DETAIL_DATA inner join DEFINITION_MST on DEFINITION_MST.SMID = DEFINITION_DETAIL_DATA.SMID Where DEFINITION_MST.MPID = 176 and val > 10000
select DEFINITION_DETAIL_DATA.SMID, Cast(Data_Value as Numeric)as Val from DEFINITION_DETAIL_DATA inner join DEFINITION_MST on DEFINITION_MST.SMID = DEFINITION_DETAIL_DATA.SMID Where DEFINITION_MST.MPID = 176 and Cast(Data_Value as Numeric)as Val > 10000
-
select DEFINITION_DETAIL_DATA.SMID, Cast(Data_Value as Numeric)as Val from DEFINITION_DETAIL_DATA inner join DEFINITION_MST on DEFINITION_MST.SMID = DEFINITION_DETAIL_DATA.SMID Where DEFINITION_MST.MPID = 176 and Cast(Data_Value as Numeric)as Val > 10000
still no working but i write like this select DEFINITION_DETAIL_DATA.SMID, Convert(Decimal,Data_Value) as Val from DEFINITION_DETAIL_DATA inner join DEFINITION_MST on DEFINITION_MST.SMID = DEFINITION_DETAIL_DATA.SMID Where DEFINITION_MST.MPID = 176 AND DEFINITION_DETAIL_DATA.SMID = 204 and Convert(Decimal,Data_Value) > 1 then it works but i want like this select DEFINITION_DETAIL_DATA.SMID, Convert(Decimal,Data_Value) as Val from DEFINITION_DETAIL_DATA inner join DEFINITION_MST on DEFINITION_MST.SMID = DEFINITION_DETAIL_DATA.SMID Where DEFINITION_MST.MPID = 176 and Convert(Decimal,Data_Value) > 1
kiran banker
-
Hi, Problem with converting varchar into Numeric select DEFINITION_DETAIL_DATA.SMID, Cast(Data_Value as Numeric)as Val from DEFINITION_DETAIL_DATA inner join DEFINITION_MST on DEFINITION_MST.SMID = DEFINITION_DETAIL_DATA.SMID Where DEFINITION_MST.MPID = 176 and Convert(Numeric,Data_Value) > 10000 Value without where condition shows like. 1 2500 2 3500 3 5000 4 10000 5 15000 6 20000 but when i add Convert(Numeric,Data_Value) > 10000 in query then its give me an error. Error converting data type varchar to numeric.
kiran banker
Your query is absolutely right. But “Data_Value” column contains invalid data, so this error occurs. Invalid data means column contains the following data: -Null -Empty -Special Characters -Spaces Please check the data if contain invalid data then remove & run query, your required result obtained.
-
Your query is absolutely right. But “Data_Value” column contains invalid data, so this error occurs. Invalid data means column contains the following data: -Null -Empty -Special Characters -Spaces Please check the data if contain invalid data then remove & run query, your required result obtained.
it contains following data. SMID Data_Value 1 2500 2 3500 3 5000 4 10000 5 15000 6 20000
kiran banker