Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    28

    Unanswered: Case insensitive string comparison

    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.

    please help.....

    thanks.....

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    where lower(itname)='test'

    rudy
    http://r937.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •