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.