Not recognising Letters & Characters from a VARCHAR table

Hi Guys,

I am having a little problem with something and was wondering if anyone had any ideas about what it could possibly be?

One of my websites pulls products from a table and it recognises the product by the “merchantProdID” in the database. Now these WERE all numbers, but after adding another merchant, the new merchant uses IDs with letters and characters. So instead of “3423542” for example, it may now be “43242-434” or “BC53453”.

This is having major effects on the frontend of my website, for example; The ID’s “170” and “170-4324” are now getting displayed on the same page and the design has gone all crazy due to this.

Does anyone know what could be causing this? The table TYPE is set to “VARCHAR”.

Im a little confused, any pointers would be much appreciated! Thanks for listening.



The column type, I guess :wink:

Please, post the query you use to extract the products.