Thanks, Tim and David!  It was just not the best way to end last week, but at least it was resolved.

I totally agree with the desire to change the design...

"If ObligationNo is not ment to contain anything but integer values, why it's varchar?

Just to increase number of lines of code and probability of errors?"

Sergiy - Thanks so much...

All -

Thanks SO MUCH for your responses!  I ended up doing a select on that column when David posted that ISNUMERIC validated non-numeric characters.  That was...

Prasad is right.  Do it in .Net - much easier and faster!

Jenise,

It looks like you are combining things like you mentioned.  First of all, your ELSE statement in the above example seems correct - you don't want to add the 'IN'...

OK...must be the "NAVISION" thing!    We're getting ready to do a Navision upgrade and I'm worried that it's going to break custom reports...

We've also encountered that in the past as well.  We have a "farm" of servers and, depending on who designed which packages (legacy...our standards change when we find this stuff),...

Yes, the reason we run our DTS packages that early is because of server traffic.  This is changing from a weekly run to a daily run - their file won't...

Awesome!  Thanks!  This should give me enough to make it happen.  There are definitely benefits to both approaches.

Yep...happened to me as well. 

OK...well. 

http://fzsccolocsw16/tiffpilot/bin/tiffpilot.exe?FN=//fzsccolocsf02/Images/DOCSOPEN/ACCT_DOC/52780/2x%301!.TIF&PD=1  wrong one

http://xxxxx/tiffpilot/bin/tiffpilot.exe?FN=%5C%5Cxxxxx%5CImages%5CDOCSOPEN%5CACCT_DOC%5C52780%5C2x%25301!.TIF&PD=1 right one

Navigation tab for JUMP TO URL

Broken one:

=Iif (Fields!STATUS.Value <> "6","javascript:void(window.open('http://xxxxx/tiffpilot/bin/tiffpilot.exe?FN=" &...

Steve,

Thanks for replying!  Here's the code in my advanced function for the navigation tab under JUMP TO URL (public info masked).

=Iif...

Yeah...it was a typo.  It does have .value in my code.

Thanks!

Joanie