Transact SQL 101 - Lesson 08_03_SQL.txt

USE adventureworkslt
GO

--Example 1
--CAST
--Character String to Integer 
SELECT CAST('12345' AS INT)
SELECT CAST('Robert' AS INT)

--Character String to a Date - Character string must be recognizable Date format
SELECT CAST('66/1/7777' AS DATETIME)

--Decimal to Integer
SELECT CAST(69.95 AS INT)

--Decimal to String
SELECT CAST(69.95 AS CHAR(10))

--Example 2
--Using to concatenate strings
SELECT 'Acct Num: ' + AccountNumber + ' Total Due: ' 
FROM saleslt.salesorderheader

SELECT 'Acct Num: ' + AccountNumber + ' Total Due: ' + CAST(TotalDue AS VARCHAR(20))
FROM saleslt.salesorderheader

--Example 3 - CONVERT
--Used to Convert Data Types and Format
SELECT 
	orderdate AS 'Original',
	CONVERT(VARCHAR(20), orderdate, 112) AS 'Style 112', 
	CONVERT(VARCHAR(20), orderdate, 101) AS 'Style 101',
	CONVERT(VARCHAR(20), orderdate, 102) AS 'Style 102'
FROM saleslt.salesorderheader

--Example 4
--MONEY to Character String
SELECT 'Acct Num: ' + AccountNumber + ' Total Due: ' + CAST(totaldue AS VARCHAR(20))
FROM saleslt.salesorderheader

SELECT 'Acct Num: ' + AccountNumber + ' Total Due: ' + CONVERT(VARCHAR(20), totaldue, 1)
FROM saleslt.salesorderheader