Обсуждение: select question

Поиск
Список
Период
Сортировка

select question

От
"STMIK Stikubank"
Дата:
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

Re: [SQL] select question

От
Chris Johnson
Дата:

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.%';

Re: [SQL] select question

От
"Roderick A. Anderson"
Дата:
On Tue, 28 Jul 1998, Chris Johnson wrote:

> > care)? I've already try :
> >
> >  select * from mhs where nim likes '94.31';
>
> select * from mhs where nim like '94.31.%';
>
Or
  select *
    from mhs
   where nim like '94.31.____';

Rod
--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814