SELECT a.* FROM Authors a WHERE a.au_lname LIKE '[K_]%' GO
For more information about LIKE I would recommend the following article:
As far as the case sensitivity is concerned, I think your issue is based on the character set and sort order for SQL Server. To determine the character set and sort order issue the following command:
For more information about sp_helpsort I would recommend the following article:
I would assume your SQL Server is configured with a case insensitive character set and sort order where a lower case letter equals an upper case letter i.e. 'k' = 'K'. I believe this installation option is preventing you from being able to complete your query as you requested.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on SQL-Transact SQL (T-SQL)
Related Q&A from Jeremy Kadlec
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ... Continue Reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ... Continue Reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.