How about:

SELECT *
FROM table_name
WHERE tblCATTYPE = 'CAT' OR tblCATDESCRIPTION = 'CAT'

HTH,
Darin Strait, MS SQL Server Development and Administration
http://home.earthlink.net/~dstrait/professional/resume.htm


----- Original Message -----
From: "Pejvak Foroohar" <pejvak@m...>
To: "sql language" <sql_language@p...>
Sent: Monday, May 07, 2001 6:14 PM
Subject: [sql_language] Search just 2 Column of SQL server


> Hi there.
> I have Big problem.
> Can u tell me exactly how can i serach just 2 column of my database,
> for example im seraching for "CAT" but i want it goes and find any CATs on
> the column "tblCATTYPE" and column "tblCATDESCRIPTION"
> Please help me ,it s very Ipmotant for me.
>
> T H A N K S    I N   A D V A N C E
> PJ