如何在两个不同的列中查看名字和名字？ [英] How to view a name in two different columns as firstname and last name?

问题描述

我希望我的名字，即Anaya Upadhyay使用select语句查看两列。

一列应该有我的名字，另一列应该是姓氏。



使用以下声明：

I want my name, i.e., "Anaya Upadhyay" to view into two columns using a select statement.
One column should have my firstname, another the lastname.

Use the following statement:

select ''Anaya Upadhyay'' as [name]

任何想法???

Any ideas???

推荐答案

declare @name  nvarchar(50)
set @name = 'Walter Hevedeich'

SELECT CASE
         WHEN @name LIKE '% %' THEN LEFT(@name, Charindex(' ', @name) - 1)
         ELSE @name
       END As FirstName,
       CASE
         WHEN @name LIKE '% %' THEN RIGHT(@name, Charindex(' ', Reverse(@name)) - 1)
       END As LastName

查看此内容..

check this one..

鉴于你的名字栏包含这种格式



[名字] [空格] [姓名]



您可以使用CHARINDEX和SUBSTRING将其拆分为2列。以下是一个例子

Given that your name column contains this format

[Firstname][space][LastName]

You can use CHARINDEX and SUBSTRING to split it into 2 columns. The following is an example

DECLARE @name AS VARCHAR(30)
DECLARE @spaceIndex AS INT
SET @name = 'Walter Hevedeich'
SET @spaceIndex = CHARINDEX(' ', @name)
SELECT SUBSTRING(@name, 1, @spaceIndex) AS FirstName,
SUBSTRING(@name,@spaceIndex,LEN(@name)) AS LastName

此外，请检查这个 [ ^ ]链接。

SELECT FirstName + '   ' + LastName  'Column_Name' FROM [Table_Name]

< br $> b $ b



尝试这样

TRY LIKE THIS

这篇关于如何在两个不同的列中查看名字和名字？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！