Hi Roland,

what do you mean with "obtain"?

I just write

SELECT myField as SomeField from SomeCursor into CURSOR curTarget

VFP doesn't care about upper/lowercase

The only idea I think I can interpret is that you display the select straight away, IOW you do not use INTO CURSOR or something the like and see the result directly.

In this case, no I have no idea, VFP gives the headers of those browse window.

What you can do is

SELECT Field1,Field2, SomeField,.... FROM ... INTO CURSOR curSomeThing

BROWSE FIELDS Field1 H:'Field1',Field2 H:'Field2', SomeField H:'SomeField'

,....

But this is hard work for something like SELECT SQL for testing ...

Agnes
>Bonjour à tous,
>
>How can I obtain an sql query with both uppercase and lowcase in column names.
>
>Ex-> MyColumn
>
>D'avance merci