Is there any way to generate a query looking something like this:

SELECT * FROM myTable ORDER BY CONVERT(DATETIME, REPLACE(myTime, '.', ':'),

or

SELECT *, CONVERT(DATETIME, REPLACE(myTime, '.', ':'), AS myDateTime FROM myTable ORDER BY myDateTime

The problem is, that I am having a column containing time values in the following format:

hh.mm (9.00, 9.30, 15.00 etc.)

And I want to be able to sort on these values.

I am using SelfServicing with SQL Server 2000.

/Stefan L. Jensen

That's not supported yet, but you can do this query in a database view and use it from within LLBLGen Pro as a TypedView or as an Entity.