Is there any way I can just do a distinct select in HQL?

I would do this in SQL: select distinct name from table1.

Where table1 has an id (int identity field), name (string field), etc.

I tried using SqlSimpleSelectBuilder and that wants a index column.
I tried using HQL, but that wants a Persister class.

I tried this:
IQuery query = this.session.CreateSQLQuery("select distinct name from table1", "names", typeof(String));
files = query.List();

But, I get this error: ""No persisters for: System.String".

I don't want a persistable object, I just want a read-only list of strings to be honest.

Any help or direction would be great.

Thanks,
Jamie

This works:

string select = "select distinct rating.FileName from MoodysLoanRating rating";
IQuery query = this.session.CreateQuery(select);
files = query.List();

Just an FYI,
Jamie

Can you do a select distinct with a where condition?
I have not seen a single example of this?


something similar to

string select = "select distinct rating.FileName from MoodysLoanRating rating where rating.Score > 600";