Re: change all the letters to small cap
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 17 Apr 2006 22:52:17 +0200
On Sun, 16 Apr 2006 22:15:01 -0700, Tiffany wrote:
it is always cybershot and i want to remove it from the real data.
Hi Tiffany,
Run the code below
BEGIN TRANSACTION
UPDATE YourTable
SET YourColumn = REPLACE(YourColumn, 'Cybershot', '')
Check results. If anything is wrong, execute ROLLBACK TRANSACTION. If
all is okay, execute COMMIT TRANSACTION.
--
Hugo Kornelis, SQL Server MVP
.
- References:
- Re: change all the letters to small cap
- From: Hugo Kornelis
- Re: change all the letters to small cap
- From: Hugo Kornelis
- Re: change all the letters to small cap
- Prev by Date: Re: change all the letters to small cap
- Next by Date: Re: Activex component can't create object
- Previous by thread: Re: change all the letters to small cap
- Next by thread: Re: Activex component can't create object
- Index(es):
