Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jamarc1
Starting Member
10 Posts |
 Posted - 2008-11-10 : 15:36:10
|
| I'm trying to combine 2 fields as in expression in report builder. I keep getting the arguments to the following function are not valid: CONCAT..Here it is..LEFT(Issue Description,160) & History EntryThoughts?? |
|
|
jamarc1
Starting Member
10 Posts |
Posted - 2008-11-10 : 15:40:45
|
| How can I concatenate 2 strings in Report Builder? Or atleast add another field? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-11 : 02:09:38
|
| what are datatypes of Issue Description & History Entry? |
|
|
|
jamarc1
Starting Member
10 Posts |
Posted - 2008-11-11 : 09:10:59
|
| They are both text fields |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-12 : 01:20:15
|
| then better to do in T-SQL using UPDATETEXThttp://www.sqlservercentral.com/articles/Miscellaneous/handlingthetextdatatype/985/ |
|
|
|
|
|
|
CONCAT 2 files