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
Have good luck for "Case Sensitive collation"