Handling of NULL? 1

[Will192]

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

 

[SQLBill]

Are you and Kaht the same person? Or do you work together?

THREAD183-1234181

-SQLBill

Posting advice: FAQ481-4875

 

[SQLDenis]

run sp_helpdb

then look at the compatibility leve, i suspect the one with NULL is set to 6.5

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLDenis]

Yep,

SELECT LTRIM(RTRIM(''))

EXEC sp_dbcmptlevel 'pubs', 60

SELECT LTRIM(RTRIM(''))

EXEC sp_dbcmptlevel 'pubs', 80

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Will192]

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.