Item Numbers using Character-Number-Character
I am having a little problem using Item numbers That begin with a character - S10046E.
When I have two products using the following:
product a; S10046E and product b; S10064F,
When I click on the product a thumbnail it takes me to product a detail page. When I click on product b it takes me to the product a detail page.
When I Take the first letter out everything works fine.
My ItemNum table is set up for varchar50.
Normally I would just take it out but I have a new manufacturer that will not be able to pull and ship product without it.
Thanks in advance,