Re: SQL question
From: <prochak_at_my-dejanews.com>
Date: 1998/09/14
Message-ID: <6tj4ml$nu6$1_at_nnrp1.dejanews.com>#1/1
Date: 1998/09/14
Message-ID: <6tj4ml$nu6$1_at_nnrp1.dejanews.com>#1/1
In article <paulsian-1209981908320001_at_1cust250.tnt1.det3.da.uu.net>,
[Quoted] paulsian_at_sprintmail.com (Paul Sian) wrote:
> In inputing data in a database using SQL plus how do I protect the &
> symbol from taking on another meaning?
>
You can use the escape character (usually backslash \ unless overridden). Look in your manual at the SET command for setting the DEFINE character and for setting the ESCAPE character. It should give and example or two on how they are used.
REM example: search for ampersand in a text column
select text from my_table
where text like '%\&%' ;
-- Ed Prochak Magic Interface, Ltd. 440-498-3702 -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member ForumReceived on Mon Sep 14 1998 - 00:00:00 CEST