How do I append string to end of sql query results?
This is a discussion on How do I append string to end of sql query results? within the SQL Server forums, part of the Microsoft SQL Server category; --> I need to append text to the end of my sql query results. For instance, my query returns a ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 03:35 AM
| ||||
| ||||
 How do I append string to end of sql query results? I need to append text to the end of my sql query results. For instance, my query returns a list of user names in firstname.lastname. I need to add @yahoo.com to each record. So the end result should be firstname.lastname@yahoo.com. What should by select statement look like? Any help?      |
|
02-29-2008, 03:35 AM
| |||
| |||
| Re: How do I append string to end of sql query results? "diesel" <dieselpb03@yahoo.com> skrev i en meddelelse news:854ece22.0407131219.6f38c10a@posting.google.c om... > I need to append text to the end of my sql query results. > > For instance, my query returns a list of user names in > firstname.lastname. I need to add @yahoo.com to each record. So the > end result should be firstname.lastname@yahoo.com. What should by > select statement look like? > > Any help? SELECT Firstname + '.' + Lastname + '@yahoo.com' AS Name FROM tblPerson easypeasy -- Med venlig hilsen Tom F Jensen FFSoft www.ffsoft.dk |
Linear Mode
