SQL - like vs matches

Posted in 1992

Walt Hultgren {rmy} — Thu, 19 Mar 92 20:35:42 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!ogicse!zephyr.ens.tek.com!shaman!hollywood!halj From: halj@hollywood.WV.tek.COM (Hal Jones) Newsgroups: comp.databases.informix Keywords: SQL like matches Message-ID: <624@shaman.wv.tek.com> Date: 19 Mar 92 21:24:12 GMT Sender: nobody@shaman.wv.tek.com Organization: Video Products Operation Posted: Thu Mar 19 13:24:12 1992 Ok maybe this is silly but I've only used the "MATCHES" keyword in SQL. Today while I was trying to answer an end-user question I noticed the "LIKE" keyword. So my question is when should you use one over the other? From what I can tell they perform the same function just slightly different with "MATCHES" providing more flexibility with ranges. =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ Hal Jones Video Products Operation Phone: (503) 685-2584 60-876 Fax: (503) 685-3998 U.S. E-MAil: <halj@orca.wv.tek.com> =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+