Another way to keep the function using * up-to-date is :

1. alter the table (which u r using in function)

2. sp_helptext 'MyFunctionName'

3. Copy the result

4. Replace "Create Function" with "Alter Function"

5. Run it and its ALL DONE!

UPDATE: for view use following

sp_refreshview 'MyViewName'