Set parameter in sql, query not working

Question

I have this code here:

DECLARE @inputform varchar
SET @inputform = 'J61807017B'

SELECT * FROM test where text1 LIKE '@inputform'

This won't give me the desired output, but when i do like this it works:

DECLARE @inputform varchar
SET @inputform = 'J61807017B'

SELECT * FROM test where text1 LIKE 'J61807017B'

Any idea?

Have you tried without the surrounding single quotes ? SELECT * FROM test where text1 LIKE @inputform — ccheneson
– ccheneson, Commented Aug 6, 2015 at 12:40

jpw · Accepted Answer · 2015-08-06 12:45:29Z

6

You need to specify the size of the variable and drop the quotes when you use it:

DECLARE @inputform varchar(20)
SET @inputform = 'J61807017B'

SELECT * FROM test where text1 = @inputform
-- or text1 like '%'+ @inputform +'%' if you want to do partial matching

If you don't specify the size for a char/varchar value the size will be 1.

From the manual:

When n is not specified in a data definition or variable declaration statement, the default length is 1.

edited Aug 6, 2015 at 12:45

answered Aug 6, 2015 at 12:43

jpw

45k6 gold badges71 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Set parameter in sql, query not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related