如何在下拉列表中连接两个列值 [英] How to concatenate two column values in dropdownlist

问题描述

我有两个名为FirstName和Last Name的列。我想在下拉列表中显示值组合为名称。

I am having two columns named as FirstName and Last Name.I want to show both the values combine as Name in dropdownlist.

推荐答案

尝试这样，

Try like this,

select FirstName+' '+LastName as Name from TABLE1

对于下拉列表，如果您需要Id，请在查询中添加ID

For Dropdown,If you need Id,Add Id in Query

select ID,FirstName+' '+LastName as Name from TABLE1

这篇关于如何在下拉列表中连接两个列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！