Re: [SQL] Case Insensitive Queries

to change this Postgres behavior? Thanks, Jim Ballard Netezza Corp. -- Original Message -- From: Mark <[EMAIL PROTECTED]> Date: 29 May 2001 10:21:15 -0600 >We tried these but it didn't work. However, that's because username is >a bpchar

Re: [SQL] RE: counting distinct rows on more than one column

alues, as in the following where that maximum is 20 and we are looking at 3 fields: select count(distinct (cast(field1 as char(20)) || cast(field2 as char(20)) || field3)) from ... Jim Ballard - Original Message - From: "Jeff Eckermann" <[EMAIL PROTECTED]> To: "