mattkovo
asked on
Help with Select Statement
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'
FROM SALES_SUMMARY
WHERE (STOREID = 14) AND (check_file_date = '7/6/2009')
I'm trying to produce this output:
Voids
12 (ok)
Any ideas here?
Here is my code:
SELECT SUM(VOID_COUNT) + '(ok)' AS 'Voids'
FROM SALES_SUMMARY
WHERE (STOREID = 14) AND (check_file_date = '7/6/2009')
I'm trying to produce this output:
Voids
12 (ok)
Any ideas here?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER