Hello
When I use CONVERT(varchar,[Date1]), the date '1900-01-01 00:00:00.000' becomes 'Jan 1 1900 12:00AM'
It is not what I was expecting really, as I was expecting the string '1900-01-01 00:00:00.000' which can then be unioned to a column containing text.
How can I convert columns into strings in a literal way?
Thanks!
Before answering this question I would encourage you to go back to previous questions you have asked for which many people spent time to answer for you and comment on whether the answers they gave you solves your problems
I usually click a like/heart to denote the preferred solution, thanks!
I would recommend you mark it as a solution or not, not just a heart 
I'll give you a hint, but based on what yosiasz has asked, you have asked this before. Have you looked up the Convert function??
As mentioned before, have a look at the CONVERT function - this part one might help you - Using CONVERT with datetime data in different formats.