Trim Text based on value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with bill_to_customer_class_meaning
The records include names like
reseller 30% discount
reseller 35% discount
end user
end user 5% discount

I want a querey to trim of the number % discount
 
Try this expression (all one line even though newsreader will wrap it onto
multiple lines):

Trim(Left([bill_to_customer_class_meaning],
InStrRev([bill_to_customer_class_meaning], " ",
InStr([bill_to_customer_class_meaning], "%"))))
 
Back
Top