Oddity with Oracle
I'm using linqpad with the IQ driver to talk to Oracle and having a minor issue.
if I do this
However if I run the resultant SQL I get a row back.
In addition, if i run it like so
but
The comparison field is a varchar2, there are no leading or trailing blanks. Anyone have a thought on this?
if I do this
from p in TableName where
p.FieldName == "12345")
select p
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
but
from p in TableName where
p.FieldName.Startswith("12345")
select p
The comparison field is a varchar2, there are no leading or trailing blanks. Anyone have a thought on this?