var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need to remove 2 characters in a query as well as add 2
I have a query where the result for a part number begins with "TD" so for example a part might be TD123456 or TD3686B1 or TD5A02.
How can I remove the TD from the part# in my query.
Also if I want to add 2 characters to the end of the part# how would that be done?
Thanks appreciate the help
For the first, look at the Mid() function. For the second, concatenate:
Mid(...) & "AB"
Happy to help, and welcome to the site by the way!