I need to create the SQL that will select all rows from a table and will add an additional empty record to the end. I will be using the results in ColdFusion (though this likely will not matter, it may be helpful information).
SELECT NAME, ID
FROM CONTACT
WHERE NAME LIKE 'T%';
What do I need to add to this to get all the names that start with T and get one extra record in my record set.
T1M
SELECT NAME, ID
FROM CONTACT
WHERE NAME LIKE 'T%';
What do I need to add to this to get all the names that start with T and get one extra record in my record set.
T1M