Re: sql statement to find carriage return

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 16 Dec 2003 22:28:15 +0100
Message-ID: <a5uutvou3ei0ov1t81mrqpedr5v2t264pg@4ax.com>

On Tue, 16 Dec 2003 15:33:14 -0500, "Bill Thomason" <billthomason_at_charter.net> wrote:

>I am looking for a simple sql statement to find carriage returns in an
>orical 9i database.
>i haven't been able to find anything to help
>
>Thanks
>Bill
>

Realise carriage return can be represented as chr(13). Realise you can use the function instr to search for chr(13) Now look in appropiate places in the sql reference and complete your homework assignment

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Dec 16 2003 - 15:28:15 CST