>My SQL was like this:
>
>

>SELECT Numero AS PrimaryKey,Session FROM Member WHERE UPPER(Username)="SOMETHING" AND UPPER(Password)="&&ETC       " ORDER BY 1
>

>
>But, this generates an error in VFP. The cause is the double ampersands. How can I adjust to support such a search in my SQL?

Michel,

Try:

SELECT Numero AS PrimaryKey,Session FROM Member WHERE UPPER(Username)="SOMETHING" AND UPPER(Password)=chr(38)+chr(38)+"ETC"