• select dbname.dbo.LPAD('88', 4, '0')

    returns '0088'

    🙂