Is it possible when generating a query to truncate the results using characters/string as a delimiter? I have a table labeled Contacts where names are listed. One of the fields is address and includes PO Box. Each address includes PO Box #####. I would like my query to return to me the addresses but I would like to truncate the return using "PO Box" as the delimiter. Is this possible without having to edit each row of my table?
Perhaps it could be done by creating a second query based on the first?
Perhaps it could be done by creating a second query based on the first?