In this example, Transact-SQL will create a new table with all columns from the rows in "old_table" in which the last name starts with "Ja." Advertisement. Article continues below this ad.

It is more efficient to change the output for a report rather than to run the query again, especially if the tables used to create the report are very large. To edit your output directly, select ...