About filtering redundant value

[sukatoa]

Is it possible to filter redundant data in a query?

For example, i have here

dog
cat
cow
cat
dog
dog
cat
cow
cat

I'm just wondering if i could have a resultset that only contains

dog, cat, cow

any suggestions?

[r035198x]

Have a look at DISTINCT.

[sukatoa]

Thank you r035198x .....