August 21, 2008 05:40pm pdt

1. angelIII 798,580
2. ee_rlee 458,453
3. capricorn1 351,496
4. mark_wills 322,678
5. chapmandew 316,112
6. aneeshatti... 188,921
7. matthews... 186,746
8. Thomasian 170,076
9. jinesh_ka... 167,181
10. sdstuber 140,527
11. jimhorn 120,720
12. peter57r 117,305
13. harfang 108,183
14. frankytee 107,144
15. DatabaseMX 97,397
16. hielo 86,250
17. TextReport 84,195
18. boag2000 77,858
19. GRayL 77,734
20. ScottPletc... 77,436
21. cactus_d... 73,646
22. dqmq 70,815
23. dtodd 62,424
24. LSMCons... 61,900
25. asvforce 57,585

1. angelIII 1,543,913
2. capricorn1 685,608
3. matthews... 476,657
4. ee_rlee 458,453
5. aneeshatti... 399,628
6. mark_wills 322,678
7. chapmandew 316,112
8. harfang 218,963
9. peter57r 217,334
10. imitchie 215,310
11. DatabaseMX 206,469
12. jimhorn 201,240
13. dqmq 194,080
14. GRayL 183,565
15. jinesh_ka... 183,470
16. sdstuber 173,025
17. Thomasian 170,076
18. frankytee 157,392
19. Lowfatsp... 148,233
20. mbizup 140,947
21. ScottPletc... 130,541
22. MikeToole 118,033
23. appari 112,578
24. DanielWilson 111,753
25. dtodd 108,346

12.17.2007 at 04:03PM PST, ID: 23029512

	[x] Attachment Details

SQL Query to concatenate two fields together

Asked by dstjohnjr in SQL Query Syntax, Databases Miscellaneous, MS SQL Server

Tags: sql, fields, query, concatenate

I am looking to create an sql query that basically says 'select firstname & lastname as fullname' and not sure of the exact syntax.

TIA!Start Free Trial

Keywords: SQL Query to concatenate two fields t…

	Title
1	How to insert firstname + lastname int…
2	One column has (lastname, firstnam…
3	SQL Server 2005 View: Merge Fir…
4	SQL syntax for concatenating columns…
5	DropDownList w/ DataSource - Ho…
6	Combining FirstName and LastName fields

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

SQL Query to concatenate two fields together

Asked by dstjohnjr in SQL Query Syntax, Databases Miscellaneous, MS SQL Server

Tags: sql, fields, query, concatenate

About this solution