Change NULL values in Datetime format to empty string

Question

I have a table which contains 'NULL' values which are of type 'Datetime'. Now i have to convert those into empty string but when when i use convert function ISNULL( [Accrued Out of Default] ,'' ) here accrued into default is of datetime type, what it does it changes null to '1900-01-01 00:00:00.000' instead of empty Then i try to convert them into varchar and apply same ISNULL(CONVERT(varchar(50), [Amort Into Default] ),'') Now I am able to convert into empty string but now those datetime are converted to string which I needed in datetime So I try to CAST, CONVERT but non of them works. CONVERT(Datetime,'ISNULL(CONVERT(varchar(50), [Amort Into Default] ),'')',120) This gives error. Is there any possible solution to this. > **Solution Hi someone answered this to do as. > ISNULL(CONVERT(varchar(50), [Amort Into Default] ,120),'') and it works I dont know why . ** JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

CASE and CAST should work: CASE WHEN mycol IS NULL THEN '' ELSE CONVERT(varchar(50), mycol, 121) END