Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.chainon-marquant.org!nntpfeed.proxad.net!proxad.net!feeder1-1.proxad.net!198.186.194.250.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail From: Lackey Newsgroups: comp.databases.ms-sqlserver Subject: Re: Collation error Date: Tue, 13 Dec 2011 14:53:33 -0800 (PST) Organization: http://groups.google.com Lines: 3 Message-ID: <29182491.77.1323816813484.JavaMail.geo-discussion-forums@prdr27> References: <3308185.1868.1323796918597.JavaMail.geo-discussion-forums@yqxx6> Reply-To: comp.databases.ms-sqlserver@googlegroups.com NNTP-Posting-Host: 12.234.70.162 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: posting.google.com 1323816907 5398 127.0.0.1 (13 Dec 2011 22:55:07 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 13 Dec 2011 22:55:07 +0000 (UTC) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=12.234.70.162; posting-account=z_KmGQoAAADCs9Qy4bD3D0ykyBjotppG User-Agent: G2/1.0 X-Google-Web-Client: true Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:866 I forgot to answer your first question. FS_Customer is a view. The CustomerName field is based on a physical field which is not calculated in any way. Thanks again!