Posted By: znouza (- Armored Pilsener -) on 'CZdatabases'
Title:     Re: SQL - zacatecnicky dotaz
Date:      Tue Jun 13 18:48:47 2000

> 
> > > select * from tabulka where charindex(pole,'retezec')>0
> > > (mozna by to slo bez toho ">0", ale jistota je jistota :) )
> > >       **      __|                              3T 
> > > Umazal jsem znouzu, sorry
> > 
> > neni lepsi: SELECT * FROM tabulka WHERE name LIKE "%retezec%" ?
> > A case sensitivita v mem priklade spociva v tom, jak mas nastaveny server.
> 
> > Aspon u Sybase ASE. Jak jine databaze nevim.
> > 
> > Martin 
> 
>   Taxem prece jen neco nasel... konkretne tu druhou moznost (LIKE). Zapomnel
> 
> sem napsat, ze tu mam PostgreSQL 7.0.
>   Co se tyka velikosti pismen, nasel sem funkci lower(), nebo tak nejak. 
> Takze bych moh dat treba ... WHERE lower(name)=lower(PARAM);
> :-) Slo by to? Jak moc je to kompatibilni? Ale ne ze bych to potreboval, 
> kdyztak necham kolegy psat case sensitive. ;-)
> 
>  
> 
> -----------------------------------------       Eagle

nee, pak teda "select * from tabulke where lower(name) like 
'%'+lower(param)+'%'"

 

     _  _    /--------                      znouza
   ( o)(o ) /__________
      ||        | |
      ||        |_|           "The game of life is hard to play..."
      **      __|                              3T