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.
>