Nevermind. I was able to develop the correct syntax. the below worked well when length of field is 3:

update table_name

set field_name = ('00'+field_name)

where len(field_name) = 3

Thanks For your continued Help.