>Hi,
>
>I converted my VFP data using Sedna Upsizing Wizard to SQL Server 2012. The data is all there and when I accessed using remote view I was able to view the data and do all searches. When I created a new main record it was created on the server. The problem is when I search for it in my app It says it's NOT FOUND!
>
>I then created a child record on data I already converted and that record was able to be read BUT when I searched for it, it also was not found!
>
>Any clues to why the newly created record on SQL Server exists but is not able to be found on my app?
>
>
>Thanks, You all have been great helping me through this conversion.
>
>Bill

Hi Bill,

Is it possible your search is not finding it because the rules for equality vary in SQL from VFP, unless you are using a fully padded parameter value?

In VFP with set exact off (the default) with a 6 char field where the field holds the value abc

? mytable.myfield = "abc" && .T.

in sqlserver

where mytable.myfield = 'abc' && not found

hth,

Hank