Re: Searching for text in a Long
From: John Homeyard <homeyard_at_worldnet.att.net>
Date: 1996/11/29
Message-ID: <329F6F98.64F1_at_worldnet.att.net>#1/1
Date: 1996/11/29
Message-ID: <329F6F98.64F1_at_worldnet.att.net>#1/1
Angelito Dizon wrote:
>
> What is the best way of SELECTing rows that contain a given text
> string in a Long column?
>
> If the column were not a Long then I could do this:
>
> SELECT * FROM mytable WHERE mycolumn LIKE %text%
>
> Thanks,
> Lito
>
> Lito Dizon
> adizon_at_us.netYou may be between a rock and a hard place. Long columns may not be used
in functions arguments, expressions or where clauses.
John. Received on Fri Nov 29 1996 - 00:00:00 CET