Re: Query help
From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Wed, 16 Jul 2003 19:29:12 +0000
Message-ID: <3118543.1058383752_at_dbforums.com>
Date: Wed, 16 Jul 2003 19:29:12 +0000
Message-ID: <3118543.1058383752_at_dbforums.com>
Did you try with chr(10) also?
update addr_tab set addr1 = replace(addr1,chr(10),' ');
-- Posted via http://dbforums.comReceived on Wed Jul 16 2003 - 21:29:12 CEST