Re: simple sql

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