code to integer and sql migration

Cindy101

Hello,

I've run into an issue and am unsure how to solve it. I've migrated an upgraded database to sqlserver but I have a problem with the Customer."No." field. The ordering is way off, I'm sure this is a code[20] to varchar(20) issue but I don't know how to resolve it (I thought this conversion would happen automagically). I've made sure that the table contains only integer compatible values but how I don't know how to switch it to int?

The issue comes up because of some funky ordering - for example

Customer No.

---

1001
10001
10002
...
9001
90001

Thanks for any help you can provide!

kriki

You can put the field property "SQL Data Type" to variant. But this means that you should do it for ALL fields in which a customer no. can be put. And some of those fields can also contain vendor nos...

Better would be to rename the customer nos.
e.g.
C01000
C10000
C10001
...