I need to select all rows where a specific character is in the column. SQL Server 2005

Posted on 2007-10-08
Medium Priority
Last Modified: 2010-03-19
I need to select all rows where a specific character is in the column.

This obviously does not work
SELECT * FROM SymbolTable  WHERE 'b' IN SymbolName

Question by:Dovberman
LVL 61

Expert Comment

ID: 20036287
SELECT * FROM SymbolTable  WHERE SymbolName = 'b'
LVL 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 200 total points
ID: 20036289
SELECT * FROM SymbolTable  WHERE SymbolName LIKE '%b%'
LVL 75

Accepted Solution

Aneesh Retnakaran earned 300 total points
ID: 20036325
another option

SELECT * FROM SymbolTable  WHERE CHARINDEX('b',SymbolName) > 0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question