Issue with CODE data type

Chowdary

Hello!

I got to check filed of type CODE values contains A..Z,1..9 and all possible combinations. I have no problem if both fields are numbers. But if field1 = 3 and field2 = A then navision saying A is gretaer than 3. But im my data it should be A is less than 3. How to solve the issue?

any ideas or previous post links of same issues are highly appreciated

Thank You
Chowdary

rafal

Sort order depends on used database (native/sql) and codepage, you don't have possibility to change this sort order. In this case, you can't sort this data like you want.

You can try to create additional key with order like you need.

There are a lot of problems with proper sorting of code fileds, and you will find on mibuso.com many information about it.

pdj

You should even be aware, that the sort order of a temporary table isn't always the same as the actual table:
http://ppe.blogs.msdn.com/b/nav/archive ... nment.aspx
I think this was changed for NAV2013, but I haven't tested it.