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 |
|
addy01
Starting Member
6 Posts |
 Posted - 2006-03-22 : 15:03:01
|
| Hello,I'm trying to combine two fields and I'm not sure how the syntax works. I have a field for CalendarMonth and CalendarYear. I'd like to combine the two to end up looking like 02-2006. Can anyone help or tell me where to look? Thanks.addy01 |
|
|
jhermiz
3564 Posts |
Posted - 2006-03-22 : 15:07:15
|
=Fields!CalendarMonth.Value & " " & Fields!CalendarYear.ValueUse the '&' symbol to concat the fields in RS.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
|
|
|
Combing text