I have a column A which is populated by application appending a unique number to the col value. Not all the records has the number. I need to get all the values of the changed column A(with numbers) to get the associated values of the column B in the result set. Table has 1 million rows.

Management group app
Financial group app# 980543
Management group app# 567345
Financial group app