Sql Server Select Query value of column from another column

Question

Hi I have table below exiting col1 col2 col3 1000 2203A 2 1375 2203 2 482 2237 3 1000 2237A 3 i want a select query to get data AS BELOW for col2 with suffix(2203A) should get COL1 value of suffixless(2203) in col1 desired OUTPUT col1 col2 col3 1375 2203A 2 1375 2203 2 482 2237 3 482 2237A 3

krishna gone · Answer

Hi For COL2 22032203A I NEED OUT PUT COL1 OUPUT AS SUFFIX LESS COL1 VALUE LIKE COL1 COL2 1375 2203 1375 2203A

Laxmidhar Sahoo · Answer

sir kindly explain briefly

Suraj Kumar · Answer

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