This would also work and keep the code simple...

SELECT *

FROM dbo.MyData

WHERE Left(mychar,1)='[';

Great question. My answer was incorrect, but I learned something that will come in handy in the future.

Watch the Young Frankenstein DVD again (it never stops being funny) while enjoying some microwave popcorn.

An option to have the AdventureWorks database included with the SQL Server installation would be helpful. Right now adding it afterwards is a bit cumbersome - at least for...

My toaster is the Find and Replace tool for Access by Rick Fisher (http://www.rickworld.com/products.html). We often use Access as the front end to our SQL Server databases...

We have definitely benefited from third-party products and I am always interested in learning about something new. If this information was available in some sort of controlled fashion on...

I guess this depends on what “best” means and what kind of data you need to store. It took me a while to decide, but in the end I...

Yup, I also ran it in SQL and got:

row1 - Vyas Mohan

row2 - Mohan Shobha

row3 - Shridhar Mohan

row4 - Sourabh Mohan

So I just tried to pick...

Which code should be used? There are two listed "SSC3D" and "SSC6"

Just the mentioning of Diet Dr. Pepper caused me to go get one. I am weak for its fizzy goodness.

Thank you. Very helpful and clearly written. I provide various reports to a good number of engineers here and they love Excel. I'll definitely be able to...

Does this tool work on Windows Server 2000 and 2003?  The site says that the product "works on Windows XP and NT only".