May I make a sacrilegious (sp?) suggestion?, why not use MySQL or PostgreSQL
if you absolutely need a LIKE search on a TEXT field?
Both support that w/o a problem.
Otherwise, maybe using a very big CHAR() field would suffice.
Good luck.
>From: Scott Prentice <sp@acdocs.com>
>To: msql-list@lists.hughes.com.au
>Subject: Re: Search in a TEXT field?
>Date: Thu, 14 Oct 1999 11:12:52 -0700
> >> argh.. what about substr?
> >
> >Or sprintf?
>
>I was hoping for an SQL query solution .. I have a feeling that if
>I have to open up each field and process it with one of these
>functions, I'd be better off leaving these as external files and
>using grep.
>
>I may be wrong though .. so I'll set up a test and see what happens.
>
>Thanks for the suggestions!
>
>...scott
>-------------------------------------------------------------------------
>To unsubscribe, go to http://www.Hughes.com.au/extras/email/
>
=====
Jesus M. Castagnetto - jcastagnetto@hotmail.com
Pilot stuff & etc.:
http://www.geocities.com/ResearchTriangle/Lab/1059/
LAB: http://www.scripps.edu/research/metallo
Metalloprotein DB: http://metallo.scripps.edu/
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST