rcavill (12/7/2009)
You need the optionMust declare the scalar variable "@Dec".
When running on a Case Sensitive collation.
Once that select statement on line 2 is adjusted then it would work.
------
Robert
I didn't even notice that capital "D"... I promise it wasn't meant to be any kind of case-sensitive trick question! 😀 Maybe a mod could fix that...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown