crishna1
asked on
SELECT statsment
I need a SELECT statement that will combine values from two coulmns and give the output as one, basically concatinate.
I have a table with columns FirstName,LastName,Phone,E mail.
I need a select statement that combines the FirstName and LastName and gives the output as one.
Basically i ahev a drop down in the front end which needs to show the entire name.
many thanks!
I have a table with columns FirstName,LastName,Phone,E
I need a select statement that combines the FirstName and LastName and gives the output as one.
Basically i ahev a drop down in the front end which needs to show the entire name.
many thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for the responce, sorry i forgot to mention, the coumns will be in the where cluase.
say something like,
Select Pers_EmailAddress from QA_Person where Pers_FirstName
+' '+Pers_LastName=values from two coulmns
how do i do it?
say something like,
Select Pers_EmailAddress from QA_Person where Pers_FirstName
+' '+Pers_LastName=values from two coulmns
how do i do it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
little bit of overcomlication in this case...
SELECT Pers_EmailAddress from QA_Person
WHERE Pers_FirstName = fname AND Pers_LastName = lname
you don't need to combine them in where clause, unless you can elaborate on your "values from two columns" and explain what you exactly mean...
Good luck,
Yurich
SELECT Pers_EmailAddress from QA_Person
WHERE Pers_FirstName = fname AND Pers_LastName = lname
you don't need to combine them in where clause, unless you can elaborate on your "values from two columns" and explain what you exactly mean...
Good luck,
Yurich
Select FirstName+' '+LastName Name, Phone, Email
From <YourTable>