i am working in postgresql with VB. how can i compare strings case insensitive in the WHERE clause. When i write "SELECT * from ITEM WHERE itname = 'test' ", i get records having itname 'test', not 'Test' or 'TEST'. how can i get all 'test' s in a query. is there any option to be set when starting postgres server.