[Technical] Export from CASES SQL contains CR/LF within fields. Can't find unique end of record.

[Con Zymaris]

On Thu, Mar 02, 2006 at 01:02:34PM +1100, Stephen Digby wrote:
> Can't seem to write  an SQL query in CASES that generates a unique 
> string start or end of record marker.
> Can't import CASES export because so many fields allow CR/LF within fields.
> Any ideas ? suggestions ?

What tool are you using for bulk record import?

Cheers,

Con Zymaris

- CEO, Cybersource Pty. Ltd.
- Director, Open Source Industry Australia, Limited.
- Convenor, Open Source Victoria (A Government-funded industry cluster.)

-- 
___________________________________________________________________________
Con Zymaris <conz at cyber.com.au> Level 4, 10 Queen St, Melbourne, Australia 
Cybersource: Australia's Leading Linux and Open Source Solutions Company 
Web: http://www.cyber.com.au/  Phone: 03 9621 2377   Fax: 03 9621 2477