Fw: two problems when importing MSSQL to filePro

[Kenneth Brody]

On 5/8/2013 3:34 PM, Richard Hane wrote:
>
> Problem number 1 solved.  For future reference for anyone doing low level
> import of MSSQL dates, their format is yyyy-mm-dd. A simple set of mid
> strings solved the problem.  Dates now work.
>
> Problem 2 is still out there.  It is called a 'Scientific Notation'.
> Only about 3% of the 18,000 BOMs have this problem.  If I could ID them I
> could do a work around.  The problem is how to do this.
[...]

How are the columns defined in MSSQL?

-- 
Kenneth Brody