Tim

Now I've got my hands on 1.03 I'm about to start developing my TEXTSEARCH function (thought I might as well go with a name I recognise and I started to add parameters.

Words to search for is easy - VarChar(512) but the text to search in is more difficult since this will be a column. I'm going to experiment with CLOB but I'd appreciate you comments on this sort of thing and just what we can do in the way of coercion with column types.

Roy Lambert

Roy,

<< Words to search for is easy - VarChar(512) but the text to search in is
more difficult since this will be a column. I'm going to experiment with
CLOB but I'd appreciate you comments on this sort of thing and just what we
can do in the way of coercion with column types. >>

As long as the types are compatible, and CLOB, CHAR, and VARCHAR are
type-compatible, then the best solution is to go with just a straight
VARCHAR parameter with no length specifier, or a CLOB.

--
Tim Young
Elevate Software
www.elevatesoft.com