This is probably simple but I can't get it to work.
What I need to do is convert a field from integer to varchar, so I can join it to a field in another table.
I have tried to produce a Computed field using the Conversion function in Query Editor, however I get the following error:
Actual: Line Expecting: ID, [A-Z], ID@, ID#, ID%, ID&, ID!, ID$, Width
Here is my expression:
CONVERSION(VARCHAR(10),DBSrrcv.dbo.recv_doc_line_tax.recv_doc_line_nbr,)
Can anyone point out what I'm doing wrong?
Thanks