>i have a trouble comparing tow varchar value, for example in my table of product the products id is varchar and i am comparing with 1 like this pr.id=1 but the query analazer return to me any product that have a 1 for example '11','13','1','21'.... i need to know if there is a form that i compare de exact values.
Try pr.id = '1'
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.