queries not returning data are for example as follows

SELECT p.productname

FROM Products P

WHERE p.productname= 'Computer233-A' and Active = '0'

where in so productname 'Computer233-A' does exist in the table however if we look by 'Computer233-A ' then it is found.

SELECT len(p.productname) as Length, p.productname, p.productnumber,p.productID_PK AS ID

FROM Products P

WHERE p.Active = '0'

(p.productname) = varchar (40)

question, i know that with len(p.productname) i only get the count for characters without the spaces, how can i get the count with spaces?

would this work?

UPDATE Products SET Products.ProductName = RTrim([Products].[ProductName])

FROM Products P

WHERE p.Active = '0'