Error converting datatype varchar to numeric

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Error converting datatype varchar to numeric

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-24 : 08:41:51

kusuma writes "I have a string of pid's to be deleted.I have a variable which contains the string. My stored procedure has the sql statement "delete from <tablename> where empid in (@empid)"
The empid has been declared as varchar.It is giving error: "Error converting datatype varchar to numeric""

Kristen
Test

22859 Posts

Posted - 2004-09-24 : 09:09:48

Someone asked a very similar question one minute after you!

See this link:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40434

Kristen