SQL Server:
SELECT region_name + ' ' + store_name FROM Geography
WHERE store_name = 'Boston';
Table Geography
| region_name | store_name |
| East | Boston |
| East | New York |
| West | Los Angeles |
| West | San Diego |
Result:
'East Boston'
"Nothing is impossible, the word itself says "I'm possible"!"
Monday, April 8, 2013
SQL String Functions > Concatenate
SQL Server:
SELECT region_name + ' ' + store_name FROM Geography
WHERE store_name = 'Boston';
Table Geography
Result:
'East Boston'
Subscribe to:
Posts (Atom)