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.
>Is the use of * to get all the fields supported in SQL Server:
>
>
>SELECT Member.* FROM Member
>
Alexandre Palma
Senior Application Architect