• You will not have any problem with prefix blanks, as the LEN function only trims the trailing blanks.....hope this helps

    Chandrachurh Ghosh
    DBA – MS SQL Server
    Ericsson India Global Services Limited
    Quality is not an act, it is a habit.