This will teach you how to format a phone number from 1234567890 to (123) 456-7890. SQL Server 2008: SELECT [Phone] AS [Phone Number] , ‘(‘+(SUBSTRING(Phone,1,3)+’)……
Here is a list of the different date formats that come standard in SQL Server as part of the CONVERT function. Tweet Tweet
FormatDateTime command Command Result FormatDateTime(Parameters!Date.Value,1) Tuesday, February 10, 2011 FormatDateTime(Parameters!Date.Value,2) 2/10/2007 FormatDateTime(Parameters!Date.Value,3) 12:00:00 AM FormatDateTime(Parameters!Date.Value,4) 00:00 Format command Command Result Format(Parameters!Date.Value,”dd-MM-yyyy”) 10-02-2011 Format(Parameters!Date.Value,”dd/MM/yyyy”) 10/02/2011 Format(Parameters!Date.Value,”MMM-dd-yyyy”) Feb-10-2011 Format(Parameters!Date.Value,”MMM-dd-yy”) Feb-10-11 Format(Parameters!Date.Value,”MMMM-dd-yy”) February-10-11 Format(Parameters!Date.Value,”MMMM dd yyyy”) February 10 2011 Also this expression: =Day(Parameters!AsOfDate.Value) & “/” & Month(Parameters!AsOfDate.Value) & “/” & Year(Parameters!AsOfDate.Value)……