Hi Roberto,


Robert DiFalco wrote:

> Actually, this became more embarrassing. Apparently the field was a BLOB
> SUB_TYPE 1 and not a VARCHAR. Is there a way to do a SELECT on the BLOB
> field for equality not containing? TIA!
>
> R.

You probably do not need to resort to UDFs. Recent versions of
Firebird are comparing TEXT blobs as if they are VARCHARs.

I suppose that if CONTAINING works, LIKE should also work. In that
case, you can try this:

SELECT some_column FROM some_table
WHERE my_text_blob LIKE 'abc%'
AND my_text_blob NOT LIKE 'abc_%'

In my current Fb (1.5 rc1), this works.

Ciao,
Marco

>
> -----Original Message-----
> From: Robert DiFalco
> Sent: Tuesday, May 06, 2003 2:53 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Embarrassing String Question
>
>
> If I have a TABLE with a VARCHAR called Name that has two records, one
> where Name = "Foo" and another where Name = "FooBar", why would a select
> on "Name='Foo'" return both records? I'm using an ASCII CHARACTER SET.
>
> R.
>
> Yahoo! Groups Sponsor
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://rd.yahoo.com/M=245454.3115308.4434529.1261774/D=egroupweb/S=1705115386:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

--
-------------------------------------
-- Marco Bommeljé
-- Bommeljé Crompvoets en partners bv
-- W: www.bcp-software.nl
-- E: mbommelj@...
-- T: +31 (0)30 2428369
-------------------------------------