Subject Re: Replication Best Practices
Author paulfilmer
Rounding errors probably (hopefully!) wouldn't crop up, since you are
only going down to 2 decimals, and not really performing any
mathematical operation on them.

You might also consider a Char() field type, in which case
the 'STARTS WITH' clause may be handy for something. eg find record
1234 from any database might be STARTS WITH '1234.'.

In either case I don't think performance would be hurt very much by
using one or the other. I tend not to use and decimal point number in
a key field, probably because you couldn't do it back in the days of

Good luck!


--- In, "Matt Nielsen" <mnielsen@c...>

> I was planing to add the DBID in addition though. What sort of
> issues might I have with the numeric field?