|
explicit conversion, Manual Conversion of Datatypes
See also:
Datatype Conversion Functions.
The majority of datatype conversions have to be explicitly named. They are called explicit conversions. The Datatype Conversion Functions listed below serve this purpose. So for example
numeric
values must be converted to char in order to combine them. The example below demonstrates the concatenation of two numbers 4 and 5; the return value is 45.
select convert(char(1),4) + convert(char(1),5)
go
-------
45
See also:
Functions
See also:
ASE T-SQL - Aggregate Functions,
biginttohex(),
bintostr(),
cast(),
convert(),
Datatype Conversion Functions,
hextobigint(),
hextoint(),
implicit conversions,
inttohex().
|
