my declaration:

```
declare @status varchar(255);
set @status = 'seated'

```

This is what my table structure looks like

```
**description**
Seated, Unpaid
Seated, Paid
Return
Seating Failed
Unseated, Paid
Upgraded
Ticketed, Paid
Unseatable
etc. 

```

My general code:

```
select  description
from    tr_status
where   description like Substring(@status,0,LEN(status))

```

What I would like to do is say where ever the description field has 'seated' in it (or whatever value is passed as my paramter). return only those lines where seated exists as part of the description. 

so only these:

```
Seated, Unpaid
Seated, Paid
Unseated, Paid

```