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