I have a Column called Name varchar(50). Data was imported from an excel
spreadsheet in all caps. How can proper case all fields in this column that
is in CAPS?The LOWER function (see BOL) can be used in an UPDATE statement to change
the contents of this field to lower case.
HTH
J
"Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
news:36B0E293-69CC-4378-95CC-1557753BA424@.microsoft.com...
> Hello,
> I have a Column called Name varchar(50). Data was imported from an excel
> spreadsheet in all caps. How can proper case all fields in this column
> that
> is in CAPS?|||If you mean literally "Proper" case (betty sue changed to Betty Sue), you ha
ve
to roll your own using the Upper and Lower functions. Here's one I dug with
a
quick Google search:
[url]http://www.novicksoftware.com/UDFofW
ase.htm[/url]
Thomas
"Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
news:36B0E293-69CC-4378-95CC-1557753BA424@.microsoft.com...
> Hello,
> I have a Column called Name varchar(50). Data was imported from an excel
> spreadsheet in all caps. How can proper case all fields in this column th
at
> is in CAPS?|||And whatever solution you find, you have to realize that there will still be
errors.
My last name can be spelled D'anjou d'Anjou or D'Anjou.
"Thomas Coleman" <replyingroup@.anywhere.com> wrote in message
news:%23Yh2NxRbFHA.2996@.TK2MSFTNGP10.phx.gbl...
> If you mean literally "Proper" case (betty sue changed to Betty Sue), you
> have to roll your own using the Upper and Lower functions. Here's one I
> dug with a quick Google search:
> [url]http://www.novicksoftware.com/UDFofW
-case.htm[/url]
>
> Thomas
>
>
> "Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
> news:36B0E293-69CC-4378-95CC-1557753BA424@.microsoft.com...
>
No comments:
Post a Comment