Post reply

Best practice for creating a mask?

  • October 27, 2008 at 7:59 am

    #200365

    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,

    "What I lack in youth I make up for in immaturity!"
    Please visit my music site at http://woundedego.com

  • October 27, 2008 at 8:13 am

    #890005

    Duplicate post. Please direct replies to http://www.sqlservercentral.com/Forums/Topic592120-373-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply