Temple University

CIS 2109 Second SQL Server Lab. SQL Queries (SELECT statements) ... (with anything), you must first convert the number to a character string. In the example below, you concatenate city, state, and zip code (converted to character string) to make up an address. ... City + ', ' + state + ' ' + CONVERT(char, Postal_Code) AS Address FROM customer_t ... ................
................