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.
Jump to PostSorry give me sample input and sample output, I see your sql statement is correct.
Sorry give me sample input and sample output, I see your sql statement is correct.
select isnull(Fran,'')+' '+isnull(Till,'') as 'Fran Till', Kejdanummer
from kabel
order by kejdanummer
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.