Ok.. I found the problem.. I needed to add a \r.. but now that opens up the question can I have a Multi replace search in replace?
Example can I do something like this in MySQL REPLACE (STRING,'\r' or '\n',' ') REPLACE(DESCRIPTION,'\r\n',' ') Wishing you the best you know you deserve, ______________________ Hello Group, Looking to use this REPLACE to strip multi line data out of my return data. I am having problems getting the \n to work correctly, any ideas? REPLACE(DESCRIPTION,\n,' ') SELECT rpad(CASE WHEN DESCRIPTION IS NULL THEN '' ELSE REPLACE(DESCRIPTION,'\n',' ') END,80,' ') as var FROM hardware; Wishing you the best you know you deserve, ______________________ Lucas Heuman CM Web Developer SRA International, Inc. FAA, WJHTC/Bldg 300, 2nd Fl., H33 Atlantic City Int'l Airport, NJ 08405 Phone 609.485.5401
