I am currenrtly trying to write a query in Microsoft Access 2010.
This query retreives a list of values from a table I have called tblTable
Some of the values are numeric and some are alpha numeric.
I am trying to do the query so that when it comes across numeric values, it places a 'Z' at the beginning of it.
If it is alpha numeric, the value is returned as it is.
I have made an attempt so far...but I keep getting an error message saying 'Missing Expression'.
My code is as follows:
SELECT PaperNo, IF( ISNUMERIC(PaperNo) = 1) THEN "Z" + PaperNo ELSE PaperNo FROM tblTable
Can anybody help and advise on what I am doing wrong at all please?