On Tue, 28 Jul 1998, STMIK Stikubank wrote:
> 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';
select * from mhs where nim like '94.31.%';