K - try

"Select Distinct Category from list"


----- Original Message -----
From: "KDayton" <alichin@h...>
To: "sql language" <sql_language@p...>
Sent: Monday, September 10, 2001 5:40 PM
Subject: [sql_language] Returning different records


> Hello List.
>
> If on a table you had a column named "Category" and there were 10
records
> all with the word "Help" as their category, how could I return a
list with
> only 1 help in it, instead of returning the entire recordset.
>
> Something like SELECT Category FROM list WHERE Category Like 'Help'
(but
> return only those that are different)
>
> Thank you for your help,
>
> Karry Dayton
>
>