Line spacing in SQL

Question

I'm an amateur programmer trying to program my medical practices EMR. Here is the code that prints our patient's medication list:

&SQLNUMBERED&SQLMRGN02&SQLTRIM&SQLCOMMA &{SELECT PRESCRIPTI,INSTRUCTIO FROM CLRXHIST WHERE COMPANY='&COMPANY' AND SSNO='&MRNO' AND ACTIVEFLAG='Y'}

and produces the following output:

1. Multiple Vitamins Essentials Multiple Vitamins, 1 tablet by mouth daily
2. Niacin 500 mg Tablet, 2 tablets by mouth daily
3. OTC supplements variable, take as directed
4. Simvastatin 40 mg Tablet, 1 tablet by mouth daily

How can I increase the spacing between each line?

Answer 1

You don't want to touch the SQL. You want to change the code that turns the query result into output.