I have a table that has a few fields that will normally appear together, along with some text, but that I want to keep as discreet fields. What is the best way to persist this?
I have these fields, all nVarChar(10):
FIELD1
FIELD2
FIELD3
FIELD4
On both input and output, I will almost invariably consider them together, like so:
[FIELD1]/[FIELD2]/[FIELD3]/[FIELD4]
In other words, I would like to refer to them as "MyFields" and have them appear like so, with the slashes between them, both during data entry and for Reporting Services.
Ie: In reporting services I want a field called "MyFields" which has that concatention.
Does this call for a Calculated Field in the schema? A view? Something else?
I'm a newbe.
Thanks,