Like Condition

[dbljackson]

I would like to pass a parameter to a stored procedure thats used in a like condition of the where clause.

Example:

Select all customer that start with "A"

Declare @Cust_no as char(4)

Select *
from customer
where customer_number like @Cust_no

Not having any luck with this. I have passed "A%". SP always
returns Null. Any comments appreciated.

TIA

 

[cdukes]

You will need to enclose the string in quotes or pass the string enclode in single quotes:

DECLARE @strSql VARCHAR(255)

SELECT @strSql = 'Select *
from customer
where customer_number like ''' + @Cust_no + '''

execute (@strSql)

The actual string you need is:

Select *
from customer
where customer_number like 'A%'

Hope this helps,

Chris Dukes

 

[dbljackson]

Thanks Chris.

Double qoutes worked.

'' + @Cust_no + ''

dj