X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 46FA8D1B4E2
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  3 Sep 2003 08:17:48 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 72857-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  3 Sep 2003 05:17:19 -0300 (ADT)
Received: from Router.ligota.eu.org (uf10.internetdsl.tpnet.pl [80.55.135.10])
	by svr1.postgresql.org (Postfix) with ESMTP id 8DA59D1B550
	for <pgsql-sql@postgresql.org>; Wed,  3 Sep 2003 05:17:14 -0300 (ADT)
Received: from wroblewski70a_46 ([192.168.0.13] helo=192.168.0.13
 ident=zgwqmu)
	by Router.ligota.eu.org with esmtp (Exim 3.35 #1 (Debian))
	id 19uTZX-0006C9-00
	for <pgsql-sql@postgresql.org>; Wed, 03 Sep 2003 11:05:03 +0200
Date: Wed, 3 Sep 2003 10:17:07 +0200
From: =?ISO-8859-2?B?TWljaGGzIFdy82JsZXdza2kgKE11ZXJ0ZSk=?=
	<muerte@ligota.eu.org>
X-Mailer: The Bat! (v1.62 Christmas Edition) Personal
Reply-To: Muerte <muerte@ligota.eu.org>
Organization: LigotaNET
X-Priority: 3 (Normal)
Message-ID: <1571737848.20030903101707@ligota.eu.org>
To: pgsql-sql@postgresql.org
Subject: Like phrase
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-2
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/10
X-Sequence-Number: 14988

Hello,

I've got a question about "LIKE" phrase. I have such a phrase:
LIKE UPPER(Key_Zawod)
And I want to write after Key_Zawod % but it doesn't work. Is there any special way to code this phrase?   

-- 
greetings

Michał Wróblewski  #GG: 111769 #ICQ: 113904213
Administrator Sieci SSK Ligota: www.ligota.eu.org
e-mail: muerte@ligota.eu.org wroblas@poczta.onet.pl
www: http://www.ligota.eu.org/muerte