substring(Tekstas from 13 for 10) "Algirdas Bajoras" <algisba.trinti@freemail.lt> wrote in message news:hj49q1$1p1$1@trimpas.omnitel.net... > Uh, nesamone parasiau. > Bet kaip gerai - irgi nezinau:) > > > > "Algirdas Bajoras" <algisba.trinti@freemail.lt> wrote in message > news:hj48sr$vum$1@trimpas.omnitel.net... >> Padarau >> >> select Prkodas as Preke, TekstoNr as Nr, substring(Tekstas,13,10) as Txt >> from PrekInfo >> where PrekInfo.Tekstas LIKE 'KP 269 galioja iki%' >> >> duoda klaida .. Token,13,10) ... >> >> Kazka ne taip darau. >> >> >> "Raimis" <somebody@nomail.com> wrote in message >> news:hj48g5$v8g$1@trimpas.omnitel.net... >>> isgnybti :) : substring(Tekstas,13,10) >>> >> >> > >