All: A table 'pksEvent' holds several thousand entries of the following values in TEXT column 'pkSpaceNO':
1189A 1190A ... 1196A These are NOT the only values with the 'A' suffix; but they are the ONLY values for which I need to change the 'A' to 'T'. I know how to do this using SRPL and UPDATE within a CURSOR, but can this be done "one-shot" with an UPDATE command, no CURSOR? 'Preciate any pointers, Bruce --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
