the sorting order in which sql server allocates the data

examples: case -sensitive

                case-insensitive

                binary,

                etc

if you give case sensitive as the allocation then you have to type the letters exactly how you have given.

for case insensitive you can type capital letters as well as small letters.

Hi,

Please refer Books Online about the collations where you can find all the information you wants to know