string matching with trailing space

From: Gary Beckler <gbeckler_at_easystreet.com>
Date: Mon, 10 Sep 2001 06:24:42 -0700
Message-ID: <tppfjtn9ital3b_at_corp.supernews.com>

[Quoted] How does Oracle perform string matching with trailing spaces in the following example?

CREATE TABLE a(

    dept CHAR(6);

INSERT INTO a VALUES ('Labor ');

SELECT * FROM aWHERE dept IN ('Labor');

Will a string match occur?

Thanks,
Gary Received on Mon Sep 10 2001 - 15:24:42 CEST