希望从MS SQL的Select查询打印自定义消息

Question

我正在尝试打印从select检索的vaules，但在MSSQL中找不到方法。

我的意思是我有查询

select str_id,value from board (this is a simplify query, the one has several joins)

这显示

CIM.MotherID,0xfffffff
CIM.MotherID,0x1234234

我想要一些类似的东西

Mother ID, Oxffffff
Mother ID, Ox123213

我试过IF语句，但没能听懂。你知道吗？

Answer 1

select STUFF(SUBSTRING(str_id,5,12),6,7,' '),value from board (this is a simplify query, the one has several joins)