将两个SQL字段与文本连接 [英] Concatenate two SQL fields with text

问题描述

如何合并两个字段和之间的文本？我已经尝试了以下所有方法，但没有任何效果……

How can I concat two fields and text in between? I've tried all of the following and nothing has worked...

([fldCode1] || ':' ||[fldCode2]) AS Method

([fldCode1] + ':' + [fldCode2]) AS Method

([fldCode1] & ':' & [fldCode2]) AS Method
                                                *** & cannot be used with varchar 

一起使用

推荐答案

这应该有效

select [fldCode1] + ':' + [fldCode2]
from tab

或如果列为数字

select cast([fldCode1] as varchar(100)) + ':' + cast([fldCode2] as varchar(100))
from tab

这篇关于将两个SQL字段与文本连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！