If you prefer not to do a cast or convert on the SQL query, you could just change the display properties of the field. In the design view of the...

Thanks for the replies.

Unfortunately the replacing of a table with a named query approach means I have to "hard code" that I want 10 results. Ideally I'd like my end...

Yeah - I know how to use query analyzer to get the top 10 results. But I want the end users of my model to be able to create their...