see the syntax below the sig block that starts with the data section
from another response.  It has a very concise approach and a more
readable approach.

Save all your current work, then open a new instance of SPSS. Make sure
that you put warnings, etc. into the output file. <edit> <options>
<viewer>. Cut-and-paste then run the syntax .

Hope this helps.

Art
Art@DrKendall.org
Social Research Consultants
University Park, MD  USA
(301) 864-5570

data list fixed /Protein (a40).
begin data.
ubiquitin protease related
Mus Musculus Growth Hormone
Mus Musculus RNA binding site
Mus Musculus Partial Cochlear
Mus Musculus protease-B
Mus Musculus Cochlear-2
Mus Musculus CoChLEAR-2
COCHLEAR
end data.
* concise but less readable approach.
temporary.
select if  index(lower(protein),'cochlear' ) ne 0.
list.
* less concise but more readable approach.
string haystack (a40) needle (a8).
compute haystack = lower(protein).
compute needle = 'cochlear'.
numeric flag(f1).
compute flag = 0.
if index(haystack, needle) ne 0 flag =1.
temporary.
select if flag eq 1.
list vars = protein.


Rowani Mohd Rawi wrote:

> Hello
>
> I like to select cases which contain a specific word in one of my string
> variable. ie. I have a string variable by the name of "Protein".
> Example of
> the values within this variable include :
>
> "ubiquitin protease related; Mus Musculus Growth Hormone, Mus Musculus
> RNA
> binding site, Mus Musculus Partial Cochlear, Mus Musculus protease-B, Mus
> Musculus Cochlear-2, ......"
>
> How do I select all the cases that contain the word cochlear in the
> Protein
> variable ?
>
> Rowani
>
>