Re: change all the letters to small cap
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 12 Apr 2006 22:17:43 +0200
On Wed, 12 Apr 2006 00:02:01 -0700, Tiffany wrote:
Hi,
Can anyone tell me how to change the names in a column to small cap.
e.g.
Name
Jane
Michael
Ronald
Eliza
to
Name
jane
michael
ronald
eliza
Your help will be greatly appreciated.
Hi Tiffany,
To change the display only:
SELECT LOWER(Name)
FROM YourTable
To permanently change the names to lowercase in your table:
UPDATE YourTable
SET Name = LOWER(Name)
--
Hugo Kornelis, SQL Server MVP
.
- Prev by Date: Re: deleting duplicates
- Next by Date: Re: change all the letters to small cap
- Previous by thread: Re: deleting duplicates
- Next by thread: Re: change all the letters to small cap
- Index(es):
