I know that if you move towards unicode, you'll probably do better by going to lowercase since I understand that there are more lowercase letters than uppercase (for some odd reason!). I think it's related to the fact that some languages have multiple lowercase letters that will map to a single uppercase letter, so there's great "distinct-ness" with lowercase. David > Is there any reason why everyone suggests to use upper() to do a case > insensitive search rather than lower()? > > Will initcap() capitalize each word in a column, or just the first word? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]