hmm ok well I ended up using substring to return just the last 2 characters as another column and then sorting on that rather then trying to do it all in one step in the order by clause. Thanks ...

Using 7.0.0-rc1-final I have an NVARCHAR(50) column named Code and I'm trying to return the first character of that column. The C# projection uses p => p.Code.Substring(0, 1) (In C#, SubString is 0 ...

Seems that the T-SQL supports what I'm trying to do, but whatever SQL crystal is using doesn't like the expression I'm using for the substring length. If I hard-code the substring length it works ...

Commented by: @mrotteveel I have updated the ticket with a corrected version of the requirements when using SUBSTRING with a start position smaller than 1; I initially incorrectly stated that it ...