> I am using firebird 2.5 version. > > > > This function Returns the starting position of the specified expression > in a character string. > > CHARINDEX ( expression1 , expression2 [ , start_location ] )
http://www.firebirdsql.org/refdocs/langrefupd21-intfunc-position.html -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ Do you care about the future of Firebird? Join the Firebird Foundation: http://www.firebirdsql.org/en/firebird-foundation/