1 - 1 of 1
PREVIOUS 1 NEXT
case when issue
I recently came across behavior of a "case when" conditional expression that really confuses me. In this case:--CASE when isnumeric('-10.00%') > 0 then convert(numeric, '-10.00%') end----the behavior is as I expected - the isnumeric() function returns 0 (cuz it ain't no number) so the "then" is...
View Answer
| Nov 17 2007 1:39 AM GMT
| asked by
Zhoover
Ms sqlserver, case when expression, T-SQL
1 - 1 of 1
PREVIOUS 1 NEXT
