Oddity with Oracle

I'm using linqpad with the IQ driver to talk to Oracle and having a minor issue.

if I do this


from p in TableName where
p.FieldName == "12345")
select p

I get no results,
However if I run the resultant SQL I get a row back.

In addition, if i run it like so


from p in TableName where
p.FieldName.Contains("12345")
select p

-No results

but


from p in TableName where
p.FieldName.Startswith("12345")
select p

gives me my row.

The comparison field is a varchar2, there are no leading or trailing blanks. Anyone have a thought on this?

Sign In or Register to comment.