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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL The isnull function requires 2 arguments.
I want to concatenate 5 address fields into 'address'. I want to add a comma between each field. I want to bypass 'prstr2' if it is nulls. Here is my statement: select prcnm, rtrim(prstr1) + ', ' + IsNull(prstr2, '', rtrim(prstr2) + ', ') + rtrim(prcty1) + ', ' + rtrim(prsta1) + ' ' +...- HotDog61
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Reporting Services
