• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Display rows in SQL table that contain a string

I need to list rows in the Keywords table where the Keyword column contains the string 'penny'

What is the tsql syntax?

KewWordID    Keyword
528            2011 penny stocks
658            2012 best penny stocks
216            2012 best stocks
905            2012 cheap stocks
767            2012 penny stocks
1185            2012 penny stocks to buy

Thanks
0
Dovberman
Asked:
Dovberman
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
select * from Keywords where keyword like '%penny%'
0
 
DovbermanAuthor Commented:
Perfect.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now