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

[Stephen Digby]

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 ?
Wasted 3 or 4 hours !!!!!!!

======================================================================================
Stephen Digby, Learning Technology Manager digby.stephen.p at edumail.vic.gov.au
Cheltenham Secondary College www.cheltsec.vic.edu.au Ph: 613 955 55 955  Fx: 9555 8617
======================================================================================



I worry that the person who thought up Muzak may be thinking up something else. Lily Tomlin 
 


Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/is/attachments/20060302/890210aa/attachment.html