Member Avatar for stesta

Hi new to the forum. I hope there is someone that can help me.
I need to retrive some data from a table in sql server.
The data is going to be used in an import to some other tool.

The problem i have is as follow.
I want to make an sql statement that only shows values from two cloumns.
The problem is that the values are in diffrent fields
See picture
I hope that some can give me a hint howto acomplish this.

sql.GIF 12.65 KB
  • 3 Contributors
  • 2 Replies
  • 74 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by VIeditorlover
Member Avatar for Ramy Mahrous

Sorry give me sample input and sample output, I see your sql statement is correct.

Member Avatar for VIeditorlover

select isnull(Fran,'')+' '+isnull(Till,'') as 'Fran Till', Kejdanummer
from kabel
order by kejdanummer

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.