Thank you, i am a little skeptical about installing third party software in the box, is there another way? , also i checked this morning and in my temp folder...

yes i went to the temp folder and it is empty and also showing 0 mg, i also clicked on the show hidden files and nothing. :ermm:

Thank you so much! you have no idea how much i apreciate it. 😀

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

would the RTRIM function also get rid of the whitespaces like tab?

I get an empty set when running your query.

Another example: i found two productnames:

"ComputerAA1" and "ComputerAA1 "

I tried to do uan update to the second one

Update Products

set...

i get SQL_Latin1_General_CP1_CI_AS

queries not returning data are for example as follows

SELECT p.productname

FROM Products P

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

it is a varchar (40).

yes, it does! thank you so much.

yes thank you!, i just need to figure out which one will work better with my transaction, your approach or the other one....

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

GO

BEGIN TRANSACTION

Select.....

Updates...

Thank...

thank you so much for your knowledge. 🙂

thank you, in your opinion this one is better than using with (rowlock) or WITH (TABLOCK)?

the serializable isolation should be put in my select transaction or in the transaction that does the insert?

thank you, sounds exactly of what i need

UPDATE Production.Product

WITH (UPDLOCK)

SET ListPrice = ListPrice * 1.10

WHERE ProductNumber LIKE '00'

If i only do a select statement then i would need to...