Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Re: [Mad_Mick] Delete Carriage return query

Jan 19, 2004, 2:48 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 19, 2004, 2:48 AM
Views: 90060
Shortcut
Quote Reply
Re: [Mad_Mick] Delete Carriage return query In reply to
I'm not a great user of Access, but how about trying to replace \n? (in MySQL you would use something like UPDATE table SET Field = REPLACE(Field,'\n',','))

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread Delete Carriage return query Mad_Mick 90421 Jan 18, 2004, 7:10 PM
Thread Re: [Mad_Mick] Delete Carriage return query 		Andy 90060 Jan 19, 2004, 2:48 AM
Post Re: [Andy] Delete Carriage return query 		Mad_Mick 89835 Jan 19, 2004, 2:45 PM
Thread Re: [Mad_Mick] Delete Carriage return query 		llccoo 89904 Jan 25, 2004, 9:23 AM
Thread Re: [llccoo] Delete Carriage return query 		Mad_Mick 89929 Jan 26, 2004, 1:52 PM
Post Re: [Mad_Mick] Delete Carriage return query 		Watts 89831 Jan 26, 2004, 3:36 PM
Thread Re: [Mad_Mick] Delete Carriage return query 		llccoo 89823 Jan 26, 2004, 3:43 PM
Thread Re: [llccoo] Delete Carriage return query 		Mad_Mick 89812 Jan 26, 2004, 4:34 PM
Post Re: [Mad_Mick] Delete Carriage return query 		llccoo 89785 Jan 27, 2004, 4:17 AM
Thread Re: [Mad_Mick] Delete Carriage return query 		Watts 89811 Jan 28, 2004, 9:39 AM
Post Re: [Watts] Delete Carriage return query 		llccoo 89808 Jan 28, 2004, 8:45 PM
Thread Re: [Mad_Mick] Delete Carriage return query 		KarlS 86295 Jul 8, 2005, 11:49 AM
Thread Re: [KarlS] Delete Carriage return query 		BI 86098 Jul 26, 2005, 3:17 AM
Post Re: [BI] Delete Carriage return query 		theryall 67804 Nov 13, 2007, 1:16 AM
Thread Re: [Mad_Mick] Delete Carriage return query 		justin.kearney 65562 Feb 29, 2008, 7:01 AM
Thread Re: [justin.kearney] Delete Carriage return query 		LaLa 62887 Jun 24, 2008, 4:47 PM
Post Re: [LaLa] Delete Carriage return query 		justin.kearney 62794 Jun 25, 2008, 5:37 AM