• I am not sure whether or not I am gonna make this solution or not, but as per your explaination,

    You want me to do somthing like following.

    1) pick column "AccountNUmber" from each table.

    2) take one by one character from eache AccountNumber

    3) e.g.

    if account number is 1234

    4) then wirte an algorithm that convert

    1 into ^

    2 into *

    3 into A

    4 into #

    somthing like this?

    5) do this for all the tables (Parent and Child tables) where "AccountNumber" Column is acting as PK or FK.

    this what you want me to do or somthing elese?