I guess that "missing" doesn't = " ". If it's a relational table it certainly isn't. I can't remember if there's a select for "missing" but you can do a range check. HTH Dave H (ps the PH list is back [log in to unmask]) -----Original Message----- From: Richard Barker [mailto:[log in to unmask]] Sent: 30 March 2004 11:05 To: [log in to unmask] Subject: [HP3000-L] Powerhouse sanity check * Please Note : This message was received from the Internet * _____________________________________________________________ Hi Could someone explain this to me. I must be missing something. I am accessing a table where there is some missing dates in a character field (HISTORY-DT). I wrote a simple check to see if the first character was blank, yet the report found nothing. I know there are definitely records in the table that correspond to the select I used. How can the following not be working: > access history > define d-test char*1 = history-dt[1:1] > choose rec-loc "VANDAM" > REP REC-LOC HISTORY-DT D-TEST > GO 2004/03/30 Virgin Express PAGE 1 Rec History D-TEST Loc Dt VANDAM 01 VANDAM 02 > SEL IF D-TEST EQ " " > GO Records selected: 0 > SEL IF D-TEST EQ "" > GO Records selected: 0 > HISTORY TYPE SCALE SCALE DEC PICTURE * REC-LOC CHAR X(8) ARC-NUMBER CHAR X(10) BOOKING-AGENT CHAR X(6) RECEIVED CHAR X(16) HISTORY-CODE CHAR X(2) HISTORY-TEXT CHAR X(64) HISTORY-DT CHAR X(14) D-TEST CHAR X(1) ================================== This message contains confidential information and is intended solely for the use of the individual or entity to whom it is addressed. If you are not the named addressee you should not disseminate, distribute or copy this email. Please inform the sender immediately if you have received this e-mail by mistake and delete this email from your system. Email transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or be incomplete. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of email transmission. If verification is required please request a hard copy version. No contracts may be concluded on behalf of Virgin Express SA/NV by means of email communication. Finally, the recipient should check this e-mail and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. ================================== * To join/leave the list, search archives, change list settings, * * etc., please visit http://raven.utc.edu/archives/hp3000-l.html * __________________________________________________________________ This message might contain confidential information. If it has been sent to you in error please do not forward it or copy it or act upon its contents, but report it to [log in to unmask] Schroders has the right lawfully to record, monitor and inspect messages between its employees and any third party. Your messages shall be subject to such lawful supervision as Schroders deems to be necessary in order to protect its information, its interests and its reputation. Schroders prohibits and takes steps to prevent its information systems from being used to view, store or forward offensive or discriminatory material. If this message contains such material please report it to [log in to unmask] Schroders does not normally accept or offer business instructions via email unless prior agreements are in place. Any action that you might take upon this message might be at your own risk. Schroder Investment Management Limited 31 Gresham Street London EC2V 7QA Authorised and regulated by the Financial Services Authority. Schroder Investment Management Limited is entered on the FSA register under the following register number: 119348 Registered Office 31 Gresham Street London EC2V 7QA Registered number 1893220 VAT registration number 243 8687 30 * To join/leave the list, search archives, change list settings, * * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *