Thanks for all the replies. Looks like what I am trying to do is not do-able in SQL Server.

As requested by Mr or Mrs. 500, here is an overview of...

This way wont work because then varchar(1000) will be returned every time. I want to call the function and have the correct string length returned based on the length parameter