Re: How to use the escape character in sqlplus

From: Harry Gaykema <hgaykema_at_proface.nl>
Date: 1998/02/02
Message-ID: <6bd8rp$g5d$1@news.worldonline.nl>#1/1

You can use the following syntax:

.....
WHERE column_name LIKE 'ABC#_D%' ESCAPE '#' .....
With the escape-character you can now search for '_' in the string.

Harry Gaykema

Steve Lucius heeft geschreven in bericht <34D0FE10.482F_at_cae204.msd.ray.com>...
>I need to find out how to esacpe the "_" character in a query statement.
>My file names use the "_" as a field delimiter. Any help would be
>greatly appreciated.
Received on Mon Feb 02 1998 - 00:00:00 CST