you'll need to use UDF's or FB1.5 to do some comparisons. Do you have the
UDF library installed?
Alan

> -----Original Message-----
> From: Robert DiFalco [mailto:rdifalco@...]
> Sent: Wednesday, 7 May 2003 9:25 AM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Embarrassing String Question
>
>
> 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.
>
> -----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.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>