Posted: Tue Apr 03, 2007 10:22 pm
The wrapping occurs because the names you chose are longer than the default column display width. Override with the FMT keyword.
Code: Select all
SELECT NAME FMT '48L' FROM DS_JOBS WHERE CATEGORY LIKE '<<Category Name>>%' AND NAME NOT LIKE '\\%';