SQL Combine Two Columns in Select Statement

by

I think this is what you are looking for –

select Address1+Address2 as CompleteAddress from YourTable
where Address1+Address2 like '%YourSearchString%'

To prevent a compound word being created when we append address1 with address2, you can use this – 

select Address1 + ' ' + Address2 as CompleteAddress from YourTable 
where Address1 + ' ' + Address2 like '%YourSearchString%'

So, ‘123 Center St’ and ‘Apt 3B’ will not be ‘123 Center StApt 3B’ but will be ‘123 Center St Apt 3B’.

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. Select top 10 records for each category
  3. How important is the order of columns in indexes?
  4. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  5. sql query to return differences between two tables
  6. SQL Server – transactions roll back on error?
  7. Difference between a User and a Login in SQL Server
  8. Convert Xml to Table SQL Server
  9. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  10. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  11. Insert Picture into SQL Server 2005 Image Field using only SQL
  12. Convert varchar to uniqueidentifier in SQL Server
  13. Execute Stored Procedure from a Function
  14. How do I group on continuous ranges
  15. Paging SQL Server 2005 Results
  16. How to compare two dates to find time difference in SQL Server 2005, date manipulation
  17. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  18. Restrict an SQL Server connection to a specific IP address
  19. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  20. SQL server identity column values start at 0 instead of 1
  21. How do you copy a record in a SQL table but swap out the unique id of the new row?
  22. How to compare dates in SQL Server
  23. How do I expand comma separated values into separate rows using SQL Server 2005?
  24. Cumulative Total in MS Sql server [duplicate]
  25. SQL query to group by day
  26. Export table data from one SQL Server to another
  27. SQL Sort Order with Null values last
  28. SQL can I have a “conditionally unique” constraint on a table?
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment