• Actually in SQL I think it's:

    '''' + Format(FieldName, '####') + '''' to output a leading zero suppressed four digit number surrounded by apostrophes.