Well the link provided isn't really about what I originally asked about. I
have not come across a SQL implementation (Postgres, MySQL, or MSSQL are
the ones I have experience in) where LIKE was "by default" case sensitive
with wildcards. That being said, I'm not the type to based my assertions
on
Thanks for the followup.
Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com
"I used to be with it, but then they changed what it was. Now, what I'm with
isn't it, and what's it seems we
By saying "OTHER DATABASES" you are implying that all other databases
agree on implementation.
I could not find the SQL official spec but anecdotally it seems this
is not the case.
http://stackoverflow.com/questions/153944/is-sql-syntax-case-sensitive
With hive you have like and rlike to chose f
On Apr 4, 2012, at 06:40 , John Omernik wrote:
> I think the like statement should be changed to be case-insensitive to match
> it's function in other DBMS Thoughts?
Out of curiosity, was there any activity on this issue? I see John's original
post in the archives (~5wks ago) with no followup
