I'm trying to format the output of and keep getting an error: Conversion failed when converting the varchar value '(ok)' to data type int.
Here is my code:
SELECT SUM(VOID_COUNT) + '(ok)' AS 'Voids'
WHERE (STOREID = 14) AND (check_file_date = '7/6/2009')
I'm trying to produce this output:
Any ideas here?