SQL在前面和后面添加一个*

Question

需要在结果的前面和后面添加一个*，以便能够通过报表生成器导出并使用条形码字体。示例*1234*

我的查询是

Select distinct    
floor(ltrim(rtrim([FGQSHO]))) as QTY,
ltrim(rtrim([QULOTN])) as Batch,
floor(ltrim(rtrim([QUQTSH]))) as BatchQty    
FROM serh
left join boll 
on serh.HVSERN = boll.QUSERN
left join bold 
on boll.QUBOL# = bold.FGBOL# and boll.QUENT# = bold.FGENT#
left join bolh 
on bold.FGBOL# = bolh.FEBOL#
left join ocri 
on bold.fgord# = ocri.ddord# 
and bold.fgitem = ocri.dditm#
where FGBOL# = '761221'

我的结果是

QTY           Batch           BatchQty
30        4615J0003  3Q20       14
30        4615J0005  4Q20       16

我正在寻找

QTY           Batch             BatchQty
30        *4615J0003  3Q20*      *14*
30        *4615J0005  4Q20*      *16*

Answer 1

使用concat():

Select distinct floor(ltrim(rtrim([FGQSHO]))) as QTY,
concat('*', ltrim(rtrim([QULOTN])), '*') as Batch,
concat('*', floor(ltrim(rtrim([QUQTSH]))), '*') as BatchQty