Hi,

I have a column of varchar 'numbers' and I would like to add leading zeros to ones that only have 3 numbers, ex. 703 = '0703'. Is there a quick update table statement I could write (psuedo code below):

if cell.text.num_chars = 3
  then '0' + cell.text

Thanks!

~Matt

I guess I really mean text formatting then... :)

I figured it out, so no need to reply.

update TABLE set Column_A='0'+ Column_A from TABLE where COLUMN_A not like '0%' and len(COLUMN_A) = 3

UPDATE Table
Set varcharNumbers = RIGHT(('000' + varcharNumbers),4)