Post reply

Database settings - handling NULL??

  • May 23, 2006 at 1:24 pm

    #114250

    Here is my query:

    SELECT LTRIM(RTRIM(''))

    If I run this in one of my databases it returns NULL, in another one it returns a blank line.  What setting determines this handling?

    I am running Windows 2000 Server with Sql Server 2000

    Live to Throw
    Throw to Live
    Will Summers

  • May 23, 2006 at 1:46 pm

    #639592

    I fixed it.  Somehow the compatibility level got set to 65 and my recovery model got changed also.  Not sure how this happened and I can't find anything in the logs to see when it happened.

    Thanks for the help.

    Live to Throw
    Throw to Live
    Will Summers

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply