How to truncate a string in Access
September 20, 2006 9:15 AM Subscribe
I'm writing an query in MS Access to get column 1 = product ID, column 2 = product Description. However, the description field has addtional spec data that I don't need. I want to remove anything after the first word, meaning remove after the first blank space. Example: Prod ID Prod Desc 10-362-3 Packing DT 12-345-5 Seal XT L-23 Desired result: 10-362-3 Packing 12-345-5 Seal I tried to use FIND or SEARCH functions to identify the position of the first blank space and to truncate everything after that. However, Access does not recoganize either FIND or SEARCH. Does anyone have any idea how to accomplish this? Thanks.