Hi,

declare @abc table

(

name1 varchar(10)

)

insert into @abc values ('GOOD')

--for lower

select lower(name1) from @abc

RESULT

good

--for UPPER

select upper(name1) from @abc

RESULT

GOOD

--for BOLD

How we make it?

ARUN SAS