krishna gone

krishna gone

  • NA
  • 15
  • 620

Sql Server Select Query value of column from another column

Jan 20 2018 2:35 AM
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

Answers (3)