That's what I'm running into. I'm not quite sure why it's doing that.

EDIT:...

I've been testing further and it turns out it's the setting of the result to the variable that's causing the issue.

Try this:

DECLARE @result as numeric(38,9),@ftest as numeric(38,8), @ResultNonConvert as numeric(38,8),...

Is there a reason why the second line uses UPPER() instead of LOWER()?

I'm trying to test this just using the code inside the function and it is taking a damn...

Wow. I have just replicated this behavior using your code.

Hmm. What version SQL Server are you using?

EDIT: In further testing, it's not the function that is the problem. Try this...

As I have said in many of my SQL Saturday presentations, Books Online is your best friend. Learn it, Live it, Love it.

Yes,...

So I'm about ready to murder a pork chop or two at this point. Anyone have a pork chop flinger handy?

Moved the package to another environment. Recreated the job (scripted...

That's what all the crazy people say...

Good idea, but if it were a permissions issue, I would not expect a syntax error.

We've had permissions issues on other packages / jobs before, and never gotten this...

Build succeeded on both.

EDIT: Although now I can see, on the Build menu,...

Steve Jones - SSC Editor (12/9/2011)

---

Brandie Tarvin (12/9/2011)

---

Oh, it's not a thread. I didn't post on this. I just found it and put a dent in my desk the shape...

Dev (12/9/2011)

---

Brandie Tarvin (12/9/2011)

---

DUH!Code

---

Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer...

DUH!Code

---

Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer knows is impossible.

Example: Brandie's code...

Let me try again, but it's going to be tomorrow. I've got a work emergency.

Gail feel free to correct me if I'm...