Home Forums SQL Server 2008 T-SQL (SS2K8) ISNULL function does not allow concatenating CHAR's in SQL 2008R2 or earlier RE: ISNULL function does not allow concatenating CHAR's in SQL 2008R2 or earlier

  • tskelley (8/1/2016)


    Yes, and thank for your pointing out the sarcasm. I have removed it from my reply. I was a little frustrated on this one, and found the comments were on the periphery of the issue.

    And yes, I continued to battle this over the weekend and found out there is an issue with some kind of "hidden" character(s) causing the view not to format correctly for older versions of SQL (2008R2 and below were affected). I had never run into an issue like this before, and the only difference in code was the ISNULL without and then with the CHAR(10) being included, but as I mentioned this was not the issue.

    Thank you all for your help,

    Tom

    Tom, thank you for posting that you had solved your problem and explaining what the issue turned out to be. It's good to have that for closure. We've all been through times when we were supremely frustrated over problem issues and the frustration is compounded when its difficult to supply the details that others are asking for. But please understand that everyone answering questions here is doing so on their own time out of the goodness of their hearts. No one (except Steve) is getting paid to do it. No one has a service-level agreement with the people posting questions, but they really do want to help. We're all glad you found your answer. Best of luck in the future.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills