Received: from mailserver.idola.net.id (mailserver.idola.net.id
	[202.152.0.227]) by hub.org (8.8.8/8.7.5) with ESMTP id
	LAA02496 for <pgsql-sql@postgreSQL.org>;
	Tue, 28 Jul 1998 11:45:28 -0400 (EDT)
Received: from goofy (smg-usr01-23.idola.net.id [202.152.5.22])
	by mailserver.idola.net.id (8.8.5/8.8.5) with SMTP id WAA28741
	for <pgsql-sql@postgreSQL.org>; Tue, 28 Jul 1998 22:34:53 +0700 (JAVT)
Message-ID: <000901bdba3f$753426e0$0500a8c0@goofy.disney.land>
Reply-To: "STMIK Stikubank" <stmiknet@mail.idola.net.id_nospam>
From: "STMIK Stikubank" <stmiknet@idola.net.id>
To: <pgsql-sql@postgreSQL.org>
Subject: select question
Date: Tue, 28 Jul 1998 22:48:55 +0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Hi all,

I have a table (mhs)  which fills as below :

nim
--------
94.31.0001
94.31.0002
95.31.0003
95.51.0004

then how can I get rows which meet with '94.31.xxxx'  (where x = don't
care)? I've already try :

 select * from mhs where nim likes '94.31';


with no success.

TIA

edhi