I agree with Grant with the addition that DRI is one of the main purposes of an RDBMS system so it should do the job at least as efficiently as...

Thanks for the nice words. I found this interesting because I had...

ntaylor (5/22/2008)

---

If consistency was considered more important...

Jeff Moden (5/21/2008)

---

...

I saw one article by a fellow recently. He...

Can you post an example of a working select?

DBA (5/21/2008)

---

so say I have this in my table

'ComputerAA1'

and someone tries to insert this

'ComputerAA1SPACE' --they will get a duplicate error for the constraint

but if they try to insert...

No. From BOL:

Tabs, etc... are not...

My fault on the empty set. In the Object_ID function you need to schema qualify the table and then...

Okay that is good. It means your database was setup to be case insensitive, now we need to know if for some reason your productname column was created with...

DBA (5/21/2008)

---

SELECT len as Length, p.productnumber,p.productID_PK AS ID

FROM Products P

WHERE p.Active = '0'

(p.productname)...

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...

Can you post an example like noted in the article referenced in my signature? If you are using equality operators you should find the matching products. There may be...

Backing up across the network is not a recommended practice. If this is necessary you need to grant access to the share to the user executing the backup. If you...

Is your column defined a fixed length (char/nchar) or variable length (varchar/nvarchar)? If fixed length you would be better off to right pad any text out to the length...

I have never tried to insert into a VFP database, but I would assume (always remembering what assume means) that you could just do something like:

Insert Into linkedserver.database..table

...