Many conversions from one datatype to another are handled automatically by Adaptive Server. These are called implicit conversions. Other conversions must be performed explicitly with the convert, hextoint, inttohex, hextobigint, and biginttohex functions. See Transact-SQL Users Guide for details about datatype conversions supported by Adaptive Server.
