Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
SQL - concatenate columns
Name: mossvector Date: May 31, 2005 at 01:55:28 Pacific OS: XP CPU/Ram: 3GHz 1GB
Comment:
Hi, how do I query so results are displayed in 1 column, e.g. 2 columns: name and address - displaying in 1 field?
Select ColumnTitle = (Column1 + Column2) FROM Mytable WHERE (Column1 is not null) AND (Column2 is not null)
The reason for the Where clause, is because in some database engines (possibly all of them) you cannot concatenate NULL values. So those rows would be ommited from the results anyway.
Summary: SQL questions In MS Access 2K SELECT vend_city+', '+vend_state+' '+vend_zip FROM Vendors ORDER BY vend_name; Does not work. Only the city is shown. How do you concatenate columns ? How do you use wil...
Summary: I have 3 SQL statements. Does anyone know how i can create simply one statement from these three. Ideally i would like the statement to return in 3 columns SELECT Count(Criticality) AS High_Impact FRO...
Summary: DBMS: SQL Server Hi, I need to rename all columns, stored procedures, triggers, and references to each, in order to ensure the names are under 30 characters. I will need to: 1) locate all objects cont...
0 
