czwartek, 15 listopada 2012

Removing spaces from some column

Quick one. Here's an example how you can remove spaces from column in database: TSQL:
update Products set ProductCode = REPLACE(ProductCode, CHAR(32),'') where id = @SomeID