Search notes:

SQL Server function: convert

convert returns the value of an expression in a different data type.
convert(datatype        , expression       )
convert(datatype(length), expression       )
convert(datatype        , expression, style)

Simple example

select
   convert(varchar(15),      1.0/3.0                    ), -- 0.333333
   convert(varchar(15), cast(1.0/3.0 as decimal(15, 12)))  -- 0.333333000000
Github repository about-MSSQL, path: /t-sql/functions/convert.sql

See also

The cast() and format functions.
T-SQL functions

Index