Received: from vidar.mbt.washington.edu (vidar.mbt.washington.edu [128.95.231.94]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB7L5bP98129 for ; Thu, 7 Dec 2000 16:05:37 -0500 (EST) (envelope-from bethg@mbt.washington.edu) Received: from mbt.washington.edu ([128.95.231.29]) by vidar.mbt.washington.edu (8.11.1/8.11.1) with ESMTP id eB7L5tU397184 for ; Thu, 7 Dec 2000 13:05:55 -0800 (PST) Message-ID: <3A2FFBB4.7B5156DA@mbt.washington.edu> Date: Thu, 07 Dec 2000 13:05:56 -0800 From: Beth Gatewood X-Mailer: Mozilla 4.76 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: trying to pattern match to a value contained in a column Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/46 X-Sequence-Number: 377 Hi- I can't figure out how to do this.... I examine a table where I think that one attribute is an abbreviation of another attribute. So-If I had a table where I had LONG_NAME and ABBR as attributes. I want something like SELECT whatever FROM my_table WHERE long_name LIKE '%[the value of ABBR in that row]%'; Of course this doesn't work... Any thoughts? Thanks- Beth