Link to home
Start Free TrialLog in
Avatar of CaptainGiblets
CaptainGibletsFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Select 2 columns in to 1 in SQL with null values

I have a very simple view that does select [column1] + [column2] as Column3

works fine, does what I want, however if [column2] is empty in a record, the view just doesn't show the entire record. How can I change this so it will show the record and just [column1] or [column2] if the other column is empty.
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CaptainGiblets