sorting on this project just equality, but general
solution would be apreciated.
Thanks,
Grant
On Mon, 20 Jun 2005 10:13:39 +0900, Tom Lane <[EMAIL PROTECTED]> wrote:
"Grant Morgan" <[EMAIL PROTECTED]> writes:
= is not working on a char(30) coloumn for me.
I want to find rows w
= is not working on a char(30) coloumn for me.
I want to find rows with equal name.
I have my database set to unicode.
SQL1
SELECT h1.key,h1.name,h2.key,h2.name
FROM table1 as h1, table1 as h2
WHERE h1.name=h2.name
and h1.OID = 730716
produces result rows where name doe not match
name is multib