Also please tell me the corresponding SQL statement.
@ character is a placeholder (format function). Link:
http://www.accessmonster.com/Uwe/Forum.aspx/access-modulesdaovba/36052/what-does-this-symbol-mean
T-SQL is a database language so it is very limited in formatting. Reporting Services on the other hand has extensive formatting features.
In T-SQL basically you have to do your own formatting with some exceptions like currency formatting:
DECLARE @Amount money = 123456890123
SELECT FormatDollar='$'+CONVERT(varchar,@Amount,1)
-- $123,456,890,123.00
T-SQL formatting example link: http://www.sqlusa.com/bestpractices2005/padleadingzeros/
Kalman Toth, SQL Server & Business Intelligence Training;
SQL 2008 GRAND SLAM
