John Cochran <[EMAIL PROTECTED]> writes: > Why isn't the upper() function working in the first query? Odd. You aren't by some chance working in a non-ASCII locale where "upper('Boulevard')" yields something besides 'BOULEVARD', are you? regards, tom lane