Sql Server Select Query value of column from another column

Hi,

For COL2 2203,2203A I NEED OUT PUT COL1 OUPUT AS SUFFIX LESS COL1 VALUE

LIKE

COL1 COL2

1375 2203

1375 2203A

sir kindly explain briefly

Hello Krishna,

You can try using below query

CREATE TABLE Existing (

col1 varchar(10),

col2 varchar(10),

col3 int

)

GO

insert into Existing

values ('1000', '2203A' , 2),

('1375', '2203', 2),

('482', '2237', 3),

('1000', '2237A', 3)

GO

--Final Query Below

select * from Existing

union

select col1, col2+ 'A',col3 from Existing

Thanks