Likely this is caused by your default collation being case-insensitive.

Try adding a collation statement to your script.

e.g. REPLACE(CHAR(228) COLLATE Latin1_General_BIN, CHAR(196), 'Y')

Sir Slicendice (1/12/2009)

John Beggs (1/11/2009)Keep in mind though, sharing spindles doesn't have to be bad. If you know the work load of the other devices sharing the spindles, you...

I wouldn't say he lied to you...but that doesn't mean you have the right picture either. My point was, the fabric architecture does not define how the data is...

@homebrew01 -- Any differences in data dispersement over your physical disks is based upon the software controlling the solution, not the access method. Neither iSCSI or FC-AL...

Colin, you bring up a very good point. The value of a SAN is in its shared storage, shared performance and better storage utilization. Unfortunately, that's a lot...

Well, I am just starting my foray into the VMWare administration world, so I don't really have a clue about what they use. It's very possible that it is...

Perry, can you link the article from MS where they hesitate on the offset recommendation?

Also, in saying that you haven't used offset but haven't had a problem, doesn't indicate that...

First, I have cleaned up the initial code listing. The commas at the end of the SELECT statements should not be there. For those of us in the...

Using square brackets [] is the solution here.

As to the existing code, there is no reason that using brackets in the DML will break the running code.

We have been given very limited information here, but...

There is no reason that SQL 2005 x64 should take 4x as long to complete that query, if you are on similar...

To get the results that you want, you can't have the "full match" join argument with the "half match" arguments, because every "full match" is also 2 "half matches". ...

Have you read the link that Matt posted? After reading the whole article, take a look at the code section just above the conclusion. That code should be...

If you go the Reporting Services route, keep in mind that Data Driven Subscriptions are not supported in Standard or Express versions.

It is pretty easy to create your own "Data...

I am not sure what tool you are using, so I won't be specific.

There should be an option in your tool to set a "Text Qualifier" and you...

Thanks for following up with the forums Marcus. Always good to see that suggestions have helped!