I am looking to manipulate a string to have a return set displayed as follows:

Field Name 1: f1
Field Name 2: f2

I have tried this query using C/C++ escape characters, under the false pretense that it would work:

SELECT CONCAT("Field Name 1: ", f1, "\n\r", "Field Name 2: ", f2 ) FROM table 1

* thought "\n\r" would be new line and return

Please be kind, I am a relative newbie.