Column Combination parameter

Question

Why I got error with this? Or is it possible to have a query like this?

select Employee.EmployeeID, Employee.LastName + ', ' + Employee.FirstName + ' ' + Employee.MiddleName as EmployeeFullName
From Employee
Where EmployeeFullName = 'someFullName'

Invalid column name 'EmployeeFullName'.

because you are trying to retrive value from nonexistent column. You should create that one and retrive values after this. — developerCoder, Aug 12 '13 at 11:45
It is not a computed column. It is a combination of nvarchar columns. — Karlx Swanovski, Aug 12 '13 at 11:58

Hiren gardhariya · Answer 1 · 2013-08-12T12:22:54.877

May be error occurred because any of field(lastname, firstname,middlename) may be null Try this

select 
Employee.EmployeeID, 
isnull(Employee.LastName,'') + ', ' + isnull(Employee.FirstName,'') + ' ' + isnull(Employee.MiddleName,'') as EmployeeFullName
From Employee
Where AuthorFullName = 'someFullName'

Edit 1)

your where condition is wrong that's why you got (Invalid column name 'AuthorFullName'. )this error.

Edit 2)

select 
    Employee.EmployeeID, 
    isnull(Employee.LastName,'') + ', ' + isnull(Employee.FirstName,'') + ' ' + isnull(Employee.MiddleName,'') as EmployeeFullName
    From Employee
    Where isnull(Employee.LastName,'') + ', ' + isnull(Employee.FirstName,'') + ' ' + isnull(Employee.MiddleName,'') = 'someFullName'

authorfullname is not an existing column that's why you get this error — Hiren gardhariya, Aug 12 '13 at 11:48

score 0 · Answer 2 · answered Aug 12 '13 at 12:03

0

SELECT FullName FROM 
( 
    SELECT 
        FullName = LastName + ', ' + FirstName + ' ' + MiddleName
        FROM Employee  
) sub 
WHERE sub.FullName = 'someFullName'

answered Aug 12 '13 at 12:03

Karlx Swanovski

2,869
9
34
67

Column Combination parameter

2 Answers2