Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dpendley
-
Handling Strings
Hi SELECT CASE WHEN DX IS NULL THEN EnvelopeName + char(13) + ' ' + Address1 + char(13) + Address2 + char(13) + ' ' + Address3 + char(13) + ' ' + Address4 + char(13) + ' ' + Postcode + ' ' ELSE DX END AS Address, Code FROM Entities This works fine but I need to refine it so...- dpendley
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
