I would like to be able to update an
nvarchar column with
e.g. if the value is currently 'ordered', I need to append the date.
I did try :
update order_line set comments = 'ordered'+ getdate () where ol_number = 10
but I received the error
Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string.
Is there a best method of achieving this please?