GSquared (5/21/2008)

---

The quick answer is update the table using RTrim.

update dbo.Table
set Column = rtrim(Column)

Since you're using Varchar data type, that will probably do it.

If it doesn't, the thing to do is take a look at ANSI_PADDING in Books Online and start checking for that.

DBA (5/21/2008)

---

SELECT     len as Length,  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'

DBA (5/21/2008)

---

SELECT     len as Length,  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'

SELECT collation_name 
    FROM sys.databases 
    WHERE database_id = DB_ID()