Re: change all the letters to small cap

On Wed, 12 Apr 2006 22:52:01 -0700, Tiffany wrote:

Thanks!

May i ask you another question. I would like to remove the name in the model
column.

e.g from CybershotDSC123 to DSC123.

Thanks in advance.

Hi Tiffany,

Depends on

a) Do you want to hide it from display but keep the data intact, or do
you want to remove it from the real data?

b) How can the computer "know" what part of the model is the company
name? Is it always "Cybershot"? Is it stored in another column in the
same table? Is the part of the model that should be left allways the
last six characters? Any other way?

--
Hugo Kornelis, SQL Server MVP
.