[Info-ingres] weird string processing request

[Roy Hann]

Martin Bowes wrote:

> Yes the tag names are known, fixed in order and number.
>
> I'm pretty sure that SIMILAR TO is a search predicate and 
> only returns a true false to a where clause and will not return a
> matching value.

You're in for a treat then.  :-)

Ingres 11 now has a substring() function which takes a regular
expression. The syntax is 

  SUBSTRING( s SIMILAR TO pattern ESCAPE esc_character [modifier] )

It's on page 126 of the PDF version of the SQL Reference Guide I
happen to have at hand.

Roy