How to use TO_Char() in SQL Server 2008

Question

I am trying to convert the SQL statement to SQL Server 2008. So how can I do this? Below is my sql statement which I want to convert. I also try to resolve from the Stackoverflow question but I am not succeeding How to use TO_CHAR function functionality

SELECT 
    C_Debt_Payment.AD_Client_ID,  
   (CASE WHEN C_Debt_Payment.AD_Client_ID IS NULL THEN '' 
         ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table1.Name), ''))),'') ) END) AS AD_Client_IDR

Thanks for your reply and comments

Answer 1

TO_CHAR is Oracle. In SQL Server, use CONVERT:

SELECT C_Debt_Payment.AD_Client_ID,  
  (CASE WHEN C_Debt_Payment.AD_Client_ID IS NULL THEN '' ELSE COALESCE(CONVERT(varchar(20),table1.name),'') END) AS AD_Client_IDR