On Mon, Feb 21, 2011 at 6:45 AM, Rafael Copquin <[email protected]> wrote: > I have a legacy vfp 6 database that I am migrating to SQL Server 2008. > > The items table has a field named "itemcode" with a character field type > of width 6 > > This field would suposedly contain alphanumeric codes, but the client > always used numeric codes, starting in '1' and ending in '999999' ------------
You could add computed column to the table that is not a real column and use that as well. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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.
