Saturday, February 25, 2012

NOCASE attribute

Does someone could explain me the NOCASE attribute in the order by line?
I cant find that anywhere.
Thanks a lot,
venusgirrlhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/vdbref/html/dvconquerydesignerconsiderationssqlserver.asp|||I read that article, bui i couldnt understand clearly for what is the NOCASE attribute.

Thank you,
venus|||The NOCASE attribute means that Upper/Lower case are considered the same.

Consider the strings "This is a test" and "this is a test". On a server that is case sensitive, those are different. On a server that is not case sensitive (in other words sp_server_info shows NOCASE on line 18), those strings are considered to be the same.

-PatP|||Thanks you !!!!!!! :))))

venus

No comments:

Post a Comment