>I think we may have one function, say, FormatValue with these parameters
>
>FormatValue(FormatVal, FieldValue)
>
>FormatVal is something like '9N'
>and the FieldValue is the actual value of the field, e.g. SSN = "123456789"

Very similar to what I did!

>
>From 9N we get 9 and N so we know that we need to have 9 digits.
>
>Our case statements would only be for A, N, date formats and also for cases where we need to use particular first character, I guess.
>
>But I'm just thinking aloud, I'm not sure exactly if I'm thinking in the right direction or how easy it would be to implement.
>
>
>>So quick and such a seemingly simple answer. It must be harder than that.
>>
>>Well, I see it is much more involved, but maybe I'm wrong. I don't understand your example. Could you use my sample and explain that further?
>>
>>Also, I would think that there must be case statements, etc., to handle the different scenarios. Should I have a case statement based on the fields, CASE tFieldName = 'SSN', etc. for each field, then parse accordingly?
>>