We have two tables with an account number field,
one is like 00012345-234
the other 00012345234
How do we strip the - out of the first example so that the values in both tables will be in the same format? I tried a search and replace, and also failed at append query.
All help appreciated.
Would like to distribute routine reports PDF format (required by the system)via Lotus Notes.
Need to be able to send the report and provide the reader to those who don't have it.
Simple ways to tackle this would be appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.