H
hughess7
Hi all
Using a query, I want to display the text in a field without its surrounding
brackets, please can you tell me the best way to achieve this?
I know you can use replace and instr functions
eg Expr2: Right([Short_Dsc],InStr([Short_dsc],")")-1) or
Expr1: Replace([short_Dsc],"(","")
but which is the best to use and how would I combine this with not
displaying the last bracket too... ?
Thanks
Using a query, I want to display the text in a field without its surrounding
brackets, please can you tell me the best way to achieve this?
I know you can use replace and instr functions
eg Expr2: Right([Short_Dsc],InStr([Short_dsc],")")-1) or
Expr1: Replace([short_Dsc],"(","")
but which is the best to use and how would I combine this with not
displaying the last bracket too... ?
Thanks