rows

hi
i have 1 table 

code item1

a pen
a pencil

b item3
b item4


i need to select any item based on code in just 1 column.

now item3 contains pen and pencil.

so i supply @item3 it gives me 

a pen
a pencil

,what i need is ,if @sign is there,it should return b item3

@works for group

how to do that?

The way I would do it is to change the structure.  I would add another table with the component elements for your item3 and item4 and then do a join to that table to return the proper components.

OK.

I M creating 1 temp table.but as this all in sp ,i need to retun in 1 single slect stm.

hwo to do that and what query should i write to get desire result,its only 1 table

my prob is i m passing value as @param

but in table it stored like param.

so i am not getting exact match