Replacing one value with other value in sql select query

Question

Hello All,

I have a table which have 60 columns

Now my requirement is I need to create a query which will select all 60 columns from the table and I have to replace TrendType column value as Quarterly if it is Monthly .

Could any one please help how to do

Answer 1

Hi，@Learner Welcome to Microsoft T-SQL Q&A Forum!

Please Try this：

create table #test
(
 column1 int ,
 TrendType varchar(20)

)
insert into #test values(1,'yearly' ),
(2,'Monthly' ),(3,'Monthly') ,(4,'Quarterly') ,(5,'Monthly' )

select column1,
case when TrendType = 'Monthly' then 'Quarterly'  else TrendType end TrendType 
from #test

Best regards, Bert Zhou

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The question is grossly unclear, but it sounds like you want this:

SELECT col1, col2, ... 
       IIF(TrendType = 'Monthly', 'Quarterly', TrendType) AS TrendType, 
        col58, col59, col60
FROM   tbl