How to merge two columns in SQL

Question

This is my Qyery

 Select FinancialId,
        ApplicationId,
        UPPER (InterestSubsidyFinancialDetail.BankName) as BankName,    
        InterestSubsidyFinancialDetail.BankId,
        BankMaster.BankName as Bank

 From   InterestSubsidyFinancialDetail

 left join BankMaster On BankMaster.BankId = InterestSubsidyFinancialDetail.BankId

This query gave me result like this:

FinancialId   ApplicationId     BankName       BankId   Bank
1              1                HARSH BANK        -1    NULL
7              3                                   1    Allahabad Bank
8              3                JFGJFGJ           -1    NULL

But i need Column "BankName" and "Bank" to be merged like :

FinancialId   ApplicationId     BankName       BankId   
1              1                HARSH BANK        -1    
7              3                Allahabad Bank     1                
8              3                JFGJFGJ           -1    

Is this possible to get result like i need? IF yes Please help me Thanks

Answer 1

you can use this.

Select FinancialId,
        ApplicationId,
        ISNULL(UPPER (InterestSubsidyFinancialDetail.BankName),'') + 
        ISNULL(BankMaster.BankName,'')
        as BankName,    
        InterestSubsidyFinancialDetail.BankId

 From   InterestSubsidyFinancialDetail

 left join BankMaster On BankMaster.BankId = InterestSubsidyFinancialDetail.BankId

Answer 2

Please try:

select 
    FinancialId,
    ApplicationId,
    ISNULL(UPPER (InterestSubsidyFinancialDetail.BankName), '')+ISNULL(BankMaster.BankName, '') as BankName,    
    InterestSubsidyFinancialDetail.BankId
From   
    InterestSubsidyFinancialDetail left join 
        BankMaster On BankMaster.BankId = InterestSubsidyFinancialDetail.BankId

Answer 3

SELECT CONCAT(BankName, Bank)
FROM InterestSubsidyFinancialDetail

Answer 4

Select FinancialId,
    ApplicationId,
    UPPER (ISNULL(InterestSubsidyFinancialDetail.BankName,''))+''+ISNULL(BankMaster.BankName,'') as BankName,    
    InterestSubsidyFinancialDetail.BankId

From   InterestSubsidyFinancialDetail

left join BankMaster On BankMaster.BankId = InterestSubsidyFinancialDetail.BankId

Answer 5

Use the COALESCE function, it is exactly what you need for this:

SELECT FinancialId,
       ApplicationId,
       COALESCE(UPPER(InterestSubsidyFinancialDetail.BankName), BankMaster.BankName) as BankName,    
       InterestSubsidyFinancialDetail.BankId
FROM   InterestSubsidyFinancialDetail
LEFT JOIN BankMaster 
     ON BankMaster.BankId = InterestSubsidyFinancialDetail.BankId