SELECT S_Key, CONVERT(DATE, S_Date) AS BillDate, 'K' + S_No AS BillNo from SalesInvoice
The DataType is numeric. i cannot change DataType from database to varchar . I just want to change here in this command. How to change this error converting DataType to numeric