Uppercase - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Development (2000)

Uppercase

Author

Topic

lane0618
Posting Yak Master

134 Posts

Posted - 2002-06-05 : 18:55:17

How do I change the following sp so that @sku is changed to uppercase?

CREATE PROCEDURE [dbo].[new_SKU]

@spNo varchar(20),
@sku varchar(20)

AS

declare @quote char(1)
select @quote = ''''

declare @ftr varchar(200)
select @ftr = 'ALTER TABLE features ADD '
select @ftr = @ftr + '[' + @sku + ']' + ' BIT null'
exec (@ftr)

declare @fin varchar(200)
select @fin = 'ALTER TABLE finish ADD '
select @fin = @fin + '[' + @sku + ']' + ' BIT NULL'
exec (@fin)

declare @ins varchar(200)
select @ins = 'INSERT INTO dbo.Data
(SKU, Spec_No)
VALUES('
select @ins = @ins + @quote + @sku + @quote + ',' + @quote + @spNo + @quote + ')'
exec (@ins)

declare @uftr varchar(200)
select @uftr = 'UPDATE features SET ' + '[' + @sku +']' + ' = 0'
exec (@uftr)

declare @ufin varchar(200)
select @ufin = 'UPDATE finish SET ' + '[' + @sku +']' + ' = 0'
exec (@ufin)
GO

thanks,
Lane

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-06-05 : 19:12:35

Hi

There is a function UPPER() that will do it. It also has a companion LOWER()

Damian

lane0618
Posting Yak Master

134 Posts

Posted - 2002-06-05 : 19:26:03

Thanks!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources