• There has been talk in this thread by some that you will only have "real" data when developing systems if you use production data. The assumption has been that the applications need to handle this. In ETL then I would agree in the main, however, many application programmes and larger ETL projects have a data cleansing stage for a reason. Sometimes the solution to bad data is to NOT code around it but to fix the data. Sometimes.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!