create sproc insert_foo @bar as varchar(77)
as
    if @bar = ''
        set @bar=null
    insert into foo (bar) values (@bar)