問題描述
在SO上搜索和搜索，無法弄清楚
嘗試將每個字段轉換為 FLOAT 無濟于事，轉換沒有讓我更進一步
如何讓下面的 case 子句返回 THEN 部分中所述的值?
Searched and searched on SO and can't figure it out
Tried CASTING each field as FLOAT to no avail, convert didn't get me any further
How can I get the below case clause to return the value stated in the THEN section?
錯誤:Msg 8114, Level 16, State 5, Line 1將數據類型 varchar 轉換為 float 時出錯.
Error: Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to float.
我的 SQL 查詢出錯的部分:
section of my SQL query that makes it error:
When cust_trendd_w_costsv.terms_code like '%[%]%' and (prod.dbo.BTYS2012.average_days_pay) - (substring(cust_trendd_w_costsv.terms_code,3,2)) <= 5 THEN prod.dbo.cust_trendd_w_costsv.terms_code
average_days_pay = 浮動
term_code = 字符
average_days_pay = float
terms_code = char
干杯！
推薦答案
嘗試使用 ISNUMERIC 處理無法轉換的字符串:
Try to use ISNUMERIC to handle strings which can't be converted:
When cust_trendd_w_costsv.terms_code like '%[%]%'
and (prod.dbo.BTYS2012.average_days_pay) -
(case when isnumeric(substring(cust_trendd_w_costsv.terms_code,3,2))=1
then cast(substring(cust_trendd_w_costsv.terms_code,3,2) as float)
else 0
end)
<= 5 THEN prod.dbo.cust_trendd_w_costsv.terms_code
這篇關于將數據類型 varchar 轉換為 float 時出錯的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！