I think you'd get a cross join from that.
Say that there was a table
CREATE TABLE foo (
c char(4)
)
Which contained some data like this:
AAA
AAa
AaA
Aaa
I would like to find only that rows that contain: AaA
Remember that the installed sort order is case-insensitive.
-Mike