SELECT * FROM NameAddress ORDER BY Last
SELECT * FROM NameAddress ORDER BY Last, First
Note: To test this code, copy it into the SQTEST23R program in RJSRPGSQL.
C Eval SQLStmt = 'SELECT * FROM NameAddress ' +
C 'WHERE Last LIKE ' + QUOT + '%' +
C %trimr(ILAST) + '%' + QUOT + ' AND ' +
C 'First LIKE ' + QUOT + '%' +
C %trimr(IFIRST) + '%' + QUOT +
C ' ORDER BY Last '
Still have questions? We can help. Submit a case to Technical Support.