>Yes Michel all the statments you do in fox are supported in SQL, the only things that changes is the functions and the types simve in VFP you can say where logicafield or Where !logicalfield in SQL you will need to say Where logicalfield = 1 or Where logicalfield = 0.

Yes, the framework does it all automatically for that conversion.

I was just wondering about the * as I never tested that on the SQL Server.

Thanks