Error message "Conversion failed when converting the varchar value 'SD8040' to data type int"
-
Hi All,
New to SQL server Management studio and trying to build basic query to extract some data. Below is query and error message I get. I know Project filed is varchar and that is why I placed single quote in where condition value. Same result even if I have no quotes or double quotes. Any help is truly appreciated.- Thank you.
SELECT
[glNumber]
,[fund]
,[department]
,[account]
,[project]
,[inactive]
FROM [D014Glwa].[dbo].[GL_GeneralLedger]
where dbo.GL_GeneralLedger.project = 'CENT01';Error message: Msg 245, Level 16, State 1, Line 2
Conversion failed when converting the varchar value 'SD8040' to data type int. - patelvoct - Wednesday, March 21, 2018 6:54 AM
I see nothing in that query which would generate that error. Is [D014Glwa].[dbo].[GL_GeneralLedger] a view, rather than a table?
-
Hi Phil- Thank you for your prompt response. GL_GeneralLedger is a table not a view. I am not sure either on what to try. Not sure about the CAST function to force conversion to Varchar for the same
statement. Any thoughts? Thank you once again- VJP - patelvoct - Wednesday, March 21, 2018 6:54 AM
Do you get the same error if you run the select without the WHERE clause?
-
Hi Lynn,
It works great without the where clause. I need to have where clause for multiple condition once I resolve or know how to resolve the issue.
Thank you
VJP - patelvoct - Wednesday, March 21, 2018 8:30 AMHi Lynn,
It works great without the where clause. I need to have where clause for multiple condition once I resolve or know how to resolve the issue.
Thank you
VJPThis suggests that the Project column is not varchar after all. Can you post the DDL (CREATE script) for the GL_GeneralLedger table?
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply