Error converting data type 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

General SQL Server Forums

New to SQL Server Programming

Error converting data type varchar to numeric

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2007-06-27 : 02:11:53

Hi

Please help me out

declare @CID numeric(3,0)

set @CID = 121

SELECT *

from Table_name

where ID Like ''''+@CID+'%'''

I am getting error like

Msg 8114, Level 16, State 5, Line 3

Error converting data type varchar to numeric.

T.I.A

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-27 : 02:20:41

quote:
Originally posted by under2811

Hi

Please help me out

declare @CID numeric(3,0)

set @CID = 121

SELECT *

from Table_name

where ID Like ''''+ cast(@CID as varchar(20)) +'%'''

I am getting error like

Msg 8114, Level 16, State 5, Line 3

Error converting data type varchar to numeric.

T.I.A

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-27 : 02:23:07

what is the datatype of ID?

Madhivanan

Failing to plan is Planning to fail

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2007-06-27 : 02:37:06

Hi

I got from one of the forum

declare @CID numeric(3,0)
declare @NewCID varchar(50)
set @CID = 121
set @NewCID = '%'+ cast(@CID as varchar(40))+'%'
SELECT * from Table_name where ID Like @NewCID

THANKS

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-27 : 02:47:43

Beware, that approach is not going to use indexes, if any, on ID column. What are you trying to achieve?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-27 : 03:49:05

quote:
Originally posted by under2811

Hi

I got from one of the forum

declare @CID numeric(3,0)
declare @NewCID varchar(50)
set @CID = 121
set @NewCID = '%'+ cast(@CID as varchar(40))+'%'
SELECT * from Table_name where ID Like @NewCID

THANKS

Answer to my question

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources