Steven
You are obviously calling this SQL from some sort of application code.
The problem you having is that the Query is being processed as a string this will mean ParamProductId
will be converted into a string representation of it's value....
So what looks like
...AND Products.product_id = ParamProductId
will actually be
...AND Products.product_id = 0191991
OR
...AND Products.product_id = BN1-502-100
For the select to work the character based value needs to in single quotes like so.
...AND Products.product_id = 'BN1-502-100'
MySQL can convert numbers automatically for comparison but when it comes to unquoted characters it treats them as column names.
If you tell use how this is being called, what language etc we might be able to advise a little further.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information