Search results

Question Another questions in regards to this ... What about if something is separated by a semicolon: KA; CX Where in the string does it change?

Thanks THANKS very much.

DB Uploaded in query tbl_adm_data query...Master Bill

In a query... simple query.

When I use this...I get a data type mismatch in criteria expression. What I am trying to delete is every thing after the first (). I only want to show the #. For example below. Currently: 16030078016(CNPVG-HKHKG), (HKHKG-USLAX) What needed: 16030078016 I tried this below...please help...

Thanks Thanks, that worked!

I am trying to remove characters. For example, I am trying to only retreive the record before the (). Can anyone help? 16061279455(HKHKG-USATL)