xyz_order = "CASE WHEN [title] LIKE N'XYZ%' THEN 0 ELSE 1 END" xyz_post = Post.create title: "XYZ Post", body: "Test cased orders." assert_equal xyz_post, Post.order(Arel.sql(xyz_order)).first ...

Probably most of the partners have already noticed this and changed the C/AL code accordingly in order to let their customized application works properly. In ALL versions of NAV up to now (NAV 2009 R2 ...