try my function and see it is easier with 1 field instead of wasting storage space.
Consider the very likely requirement to report the most recent revision of all Quotes.
Your single field must first be parsed to extract the QuoteMaster. Group By that then use the Max of the QuoteRevision substring or QuoteDate.
Using your function to do the parsing, all the data must be hauled over to be processed in VBA. Slow and processor intensive.
Using two fields we find the latest set of quotes with Group By the QuoteMaster field and the Max of the QuoteRevision. With indexes and the whole job done in the engine, the results are virtually instant.
Performance is far more important than saving what would probably amount to fractions of a cent in storage cost.
You have always been excessively enamoured with user defined functions because they make the query look tidy. Tidy doesn't mean efficient. You should focus more on getting the engine to do the work..