I would do it like how Remi suggested. Just use the collate function and have the right capitalization in the Where clause:

To find lower case f:

select titledesc from tblproducts...

Yeah, that is pretty useful. I've been wanting the headers too. Thanks, chewrock!

You actually don't need to change to tab delimited to paste into Excel. You can do it from the standard Grid. Just click on the column name to select it....

You all probably already know this, but if you right-click an object in the browser and select Scripting Options, you can set some useful features. I like including extended properties,...

I love this type of article/discussion. I find tips from seasoned professionals very interesting and helpful.

I only have one qualm about using the templates and the auto scripting features:...

Regarding the dropping the table task: Make sure that you use the slanted quotes around the table name, not just the regular single quotes. They seem to be necessary. You...

Yeah, I've also setup a filter. However, it's very concerning for those of us whose companies send out legitimate emails actually requested by the customer. I hope their spam review...

Thanks for the clarification. However, that then means I do, in fact, need to worry about the temp table being dropped.

Let me clarify a little more about my concern. I'm...

I was checking for existence as a failsafe. When you run the code multiple times in the same session, it would error out if the temp table was not dropped....

What counter logs do you regularly keep track of? And what are you looking for in the trc file/report? I'm pretty new to performance tracking (as opposed to optimization) and...

BTW, am I correct in my thinking that the triggers will be dropped?

At my company, it is critical that we accurately maintain item status. Whether or not an item is active on the website is a complicated set of conditions (there's a...

I think that is the only way. Besides, it really is the correct way to do it and is a good habit to have. Since you're inserting back into itself,...

The "i" reference is a table alias. It's a usefull shorthand, particularly when dealing with long table names.

For example, the following query:

SELECT tblProductsWebSetting.SKU, tblProductsWebSetting.Title, tblProductsBibliographicInfo.Author FROM tblProductsWebSetting LEFT JOIN...

There is currently a thread going that may answer your question. Take a look at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=168132

Let us know if your situation is different and we can help you...