Thank this author by sharing:
Function to format phone numbers entered as text.
alternative to Format function in VB.Net
Is Format Functions Avail in SQl Server?
date format using convert function
You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cas...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.