如何获得与Colum数据合并的输出？ [英] How Do I Get Output Merged With Colum Data?

问题描述

我的表员工ID和姓名带有Sql语句：

I have table Employee with ID and Name with Sql statement :

SELECT  id
      , Name
      , CASE RIGHT(Name, 1)
          WHEN 'o' THEN 'YES'
          WHEN 'i' THEN 'NO'
        END AS SomeText
FROM    dbo.[Employee];

输出是Name =Ronaldo和SomeText =No。

输出是否有可能是SomeText =No。Ronaldo？

the ouput is Name = "Ronaldo" and SomeText = "No".
Is it possible the output to be SomeText = "No.Ronaldo" ?

推荐答案

试试这个：

Try this:

SELECT  id
      , CONCAT(Name, '.', CASE RIGHT(Name, 1)
          WHEN 'o' THEN 'YES'
          WHEN 'i' THEN 'NO'
        END) AS NewName
FROM    dbo.[Employee];

如需了解更多信息，请参阅：< a href =http://msdn.microsoft.com/en-us/library/hh231515.aspx> CONCAT（Transact-SQL） [ ^ ]

这篇关于如何获得与Colum数据合并的输出？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！