Hi,

Is there a way to do something like this in LLBLGen? The ItemText field in the db is an ntext datatype (and I can't change it):

ORDER BY cast(i.ItemText as varchar(1000))

TIA, Jack

No that's not possible at the moment.

One way to solve this is by adding a computed column to the table which has as value the cast, then sort on the computed column.