两个字段可以合并吗

[u010072032]

select item_name as ab,retailer as abc from tbl_productInfo where item_name Like '%a%' or retailer Like '%a%'


现在做一个查询功能，我想把 item_name字段内容和retailer 字段合并成一个字段

[叶子]

字段是字符串类似的话，直接拼接即可。 如果是int类型的可以转一下再拼接。

[chuanzhang5687]

select item_name retailer as abc from tbl_productInfo where item_name Like '%a%' or retailer Like '%a%'

[chuanzhang5687]

select item_name  +  retailer as abc from tbl_productInfo where item_name Like '%a%' or retailer Like '%a%'

[叶子]

select item_name+retailer as abc from tbl_productInfo 
where item_name Like '%a%' or retailer Like '%a%'

select ltrim(item_name)+ltrim(retailer) as abc from tbl_productInfo 
where item_name Like '%a%' or retailer Like '%a%'

[骑着蜗牛去爬山]

select col= item_name+retailer from tbl_productInfo where item_name Like '%a%' or retailer Like '%a%' select item_name as ab from tbl_productInfo where item_name Like '%a%' union all select retailer from tbl_productInfo where retailer Like '%a%'

[u010072032]

我是要把两个字段显示掉一排上面去比如 item_name retailer ------------------------------- abc cab cad bab ddda bbca 结果显示为 abc cad ddda cab //retailer 字段 bab bbca 像这样的可以实现吗？

[發糞塗牆]

引用 6 楼 u010072032 的回复:

我是要把两个字段显示掉一排上面去比如 item_name retailer ------------------------------- abc cab cad bab ddda bbca 结果显示为 abc cad ddda cab //retailer 字段 bab b……

那用union all就可以了啊

[u010072032]

全都都是高手

[小风渝]

select item_name as ab,retailer as abc from tbl_productInfo where isnull(item_name,'')+isnull(retailer,'') Like '%a%'

[u010072032]

select distinct '<strong> Name:</strong>'+item_name as product,item_name from tbl_productInfo where item_name Like '%a%' union all select distinct '<strong> Number:</strong>'+item_number as product,item_number from tbl_productInfo where item_number Like '%a%' union all select distinct '<strong> Group:</strong>'+product_name as product,product_name from tbl_product where product_name Like '%a%' union all select distinct '<strong> License:</strong>'+number as product,number from tbl_lecense_number where number Like '%0%' 合并显示怎么让他显示不超过10条数据啊。