declare @s varchar(10)
set @s = 'alphaBETA'
print upper(@s)
print lower(@s)