>I have a field Table1.field1 with value "AAA"
>When I try SELECT * FROM Table1 WHERE field1 == "aaa", it retrives the record with "AAA" too. How to make SELECT - SQL case-sensitive ?
>Perhaps I have a wrong environment setting.
>
>Please help. Thankx

Dino,

Does SET('COLLATE') = 'GENERAL'? If so, try setting it to "MACHINE".