garethtnash
asked on
Conversion failed when converting the nvarchar value 'China Exclusive Products - purchases inc Paper Bags' to data type int.
Umm SQL conversion query...
My Select statement is -
ID is an Int
Code is an INT
[General-Ledger-Account] is nvarchar(100)
Please advise work around..
Thank you
My Select statement is -
SELECT
ID,
Code + [General-Ledger-Account]
AS NominalCode
FROM dbo.[Nominal-Codes]
Order by Code
ID is an Int
Code is an INT
[General-Ledger-Account] is nvarchar(100)
Please advise work around..
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER