Assuming dept is required, the following 3 results were found.
the smallest data value (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example: SELECT Date, Reservation, Contact, JobTitle, Dept FROM...
and I add the following parameters: p_RequestID specified as "ID (Leave)"... this is the ID of the Leave form record. p_Dept as the name of the "Department"... this is found on the Employee form not the leave form. p_LeaveFrom this is the value of...
Smith-Jones HEAD OF IT SERVICES Head of IT Services FLAT 123A Flat 123A MRS. O'CONNOR-MCDONALD Mrs. O'Connor-McDonald ORG_DEPT_STATUS Org_Dept_Status SEND.HELP.NOW Send.Help.Now PO BOX 1234 PO Box 1234 B'MTH BH1 3AB B'mth Bh1 3Ab 123 THE WORLD'S END 123...