Re: simple sql

thanks neil_rutherford@yahoo.com wrote: > You'll have to be a bit more explicit, give examples, > if this is done in pure SQL, even subscripting won't help, because > this only subscripts the absolute position within a string. > There are some new functions available in 7.30, check them out... > but is blows me away why you want to return a character position > from a SQL statement... that's assuming you're using SQL. > > If you are using C, then use the strchr(), otherwise in 4GL, write > a routine to loop through the string until the character is found > and return it's position..... > > In article <37364CB0.F1A28EC1@auckland.ac.nz>, > Bridget <b.vanderleek@auckland.ac.nz> wrote: > > Hi > > > > I'm at bit stuck (monday morning and all). I need to find the exact > > position of a character in a string (ie the first occurance of the > > letter a in the string 'databases' this should return as 2 or > something > > like that) can someome volunteer the answer for me. > > > > thanks in advance > > Bridget > > > > > > --== Sent via Deja.com http://www.deja.com/ ==-- > ---Share what you know. Learn what you don't.---