Kad tiktu abiem atvejams :  "galioja" ir "Galioja" pabandyk  UPPER funkcija
where UPPER(PrekInfo.Tekstas) LIKE 'GALIOJA IKI%'



"Algirdas Bajoras" <algisba.trinti@freemail.lt> wrote in message 
news:hj4c3r$5k8$1@trimpas.omnitel.net...
> Didelis aciu
> Kazkas gavosi. Vadinasi tikrai FireBird DBVS.
> Tik ten kartais pasitaiko "galioja" ir "Galioja",
> bet per 2 kartus  ishsisuku.
>
> Va taip.
>
> select Prkodas as Preke, TekstoNr  as Nr, substring(Tekstas from 13 for 
> 10)
> as Txt
> from PrekInfo
> where PrekInfo.Tekstas LIKE 'galioja iki%'
>
> PREKE NR TXT
> 1032002 2 2010.07.
> 1101008 23 2008,08
> 1101008 24 2008,08
> 1101008 60 2009 12
> 1101008 63 2009 12
> 1101008 75 2010 03
> 1102002 100 2010.12men
> 1103005 4 2010.03.12
> 1103005 6 2010.03.12
> 1103005 7 2010.03.12
> 1103005 8 2010.03.12
> 1103005 10 2010.03.12
> 1105001 364 2009.12.31
>
>
> "Jornada Del Muerto" <ask@me.email> wrote in message 
> news:hj4are$3hv$1@trimpas.omnitel.net...
>> Tada SUBSTRING sintakse, RTFM : 
>> http://www.firebirdsql.org/refdocs/langrefupd15-substring.html
>>
>>
>> "Mindaugas J." <mindaugas@i-solutions.lt> wrote in message 
>> news:hj4ahn$33r$1@trimpas.omnitel.net...
>> "Algirdas Bajoras" <algisba.trinti@freemail.lt> wrote in message 
>> news:hj48kq$vgp$1@trimpas.omnitel.net...
>>> Del SQL nezinau, koks, cia "Steko" apskaita.Kazkad jie minejo, kad 3.Ar 
>>> gali
>>> toks buti?
>>
>> Steke stovi FireBird DBVS.
>>
>> -Mindaugas J.
>>
>
>