• If you are concerned about formatting output, you would be far better off handling all of that through whatever application you're using for the user interface. If you must pre-format in SQL Server, take a look at the CONVERT function in Books Online.

    If you are having issues with how SQL Server is interpreting inputted dates, take a look at this article.

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]