Re: SQL Puzzle

From: monton <monton_at_qni.com>
Date: Sat, 19 Dec 1998 12:22:52 -0600
Message-ID: <75gr4c$437$1@scoop.suba.com>

Peter,

The result would be :

DB_NAMES

---

oracle
sybase
ingress

The reason for this is that when you utilize %CHARACTER% in a like expression it will report back to you an tuples that consist of that character.

Keith
monton_at_qni.com

Peter Fullbright wrote in message <36797276.BD8CEDD3_at_hotmail.com>...
>I am trying to understand the function of escape character while using a
>LIKE operator. Keep in mind, that '%' is the escape character in the
>following query. Please let mw know what the output is and how it works.
>The table 'databases' has one column 'db_names'.
Received on Sat Dec 19 1998 - 12:22:52 CST