I'm doing an upgrade on a 3.7 database, and then using the new 5.0 sp1 db on a SQLServer. I'm having an issue with one of the code datatypes - "Job Task"."Job Task No."
I understand how sql wants to sort the Code fields, but this field I need to be sorted the correct (accounting) way.
I found this:http://wiki.dynamicsbook.com/index.php? ... NAV_vs_SQL
Which definitely explains what I want to do, but I don't know how to go about doing it. The field is all numeric in all companies, so I shouldn't run into any problems, once I know what I'm supposed to do
Thanks in advance.