= 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
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