Stephen Russell wrote: >> Not sure if he'll be up for splitting them up. That sounds like a >> recipe for disaster (or Vistaster...LOL), because if he wanted a >> character field, he would have asked for it. I don't want to split up a >> numeric field. Sure, it can be done, but that sounds like asking for >> trouble. >> >> Thanks for the idea, though! It was appreciated! > ----------------------------------------------------------------------------- > > You could keep it as char() and have him do the conversion on his > side. You indexs should work for finding. He/she can do the > conversion from their side as needed. > > >
Steve, an Integer field stores values from -2,xxx,yyy,zzz to 2,xxx,yyy,zzz so how would leaving it as a 8 byte char() work better? That's one digit less, if I understand you correctly. ??? Are you trying to multi-thread again? <g> _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
