Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to convert data in upper case

Author  Topic 

mr_dayal
Starting Member

37 Posts

Posted - 2008-07-01 : 05:29:21
suppose I have two tables with same structure. Name and age columns..
In One table Data in name column is in lower case.
Now I want to import data from first table to second table but name's in upper case. Is there any way to do so?

Mr Dayal

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-01 : 05:37:45
use function upper()


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

mr_dayal
Starting Member

37 Posts

Posted - 2008-07-01 : 05:40:47
It's Done..
I was using Toupper

Mr Dayal
Go to Top of Page
   

- Advertisement -