I am creating a datacolumn in which I am assigning the value of expression
"REPLACE(CONVERT(VARCHAR(11), my_date, 106), ' ', '-') +' - '+ my_series"
but I am getting an error - "The expression contains undefined function call REPLACE()"
After I have removed Replace I am getting the error for varchar.
How can I convert the date in that format - 01-Apr-2010