Select syntext for database search

i have a database and a table one colums with items name
des items
1 pen,pencile
2 rubber,scale

all are in one column with seperated with coma when search from only pen how it is possible to show me row for 1 whole row

like search pen ok .... show me 1 pen,penciles

Newbie Poster

4 posts since Jul 2010

Reputation Points: 10

Solved Threads: 0

Assuming the name of the table is Office AND that the name of the column is stationary, try:
SELECT * FROM Office WHERE stationary LIKE '%pen%'

Veteran Poster

1,124 posts since Dec 2007

Reputation Points: 116

Solved Threads: 243

This question has already been solved

You