No-break space not recognized as white-space in SQL Server

is there any settings in SQL server 2005, so that no-break space will be recognized as white space in SQL Server