Use two stored procedures to select case-insensitive sort orders:
sp_helpsort
sp_configure
sp_helpsort lists the available case-insensitive sort orders.
sp_helpsort ----------- Name ID ------------------------- nocase_eucgb 52 nocase_cp936 52 nocase_gb18030 52 nocase_eucjis 52 nocase_sjis 52 nocase_deckanji 52
To switch to a case-insensitive sort order, enter:
sp_configure 'default sortorder id', 52
