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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER