Procedure parameter problems

[plazmo]

i shortned this procedure. but im havving problems with the like clause in this, it says it cannot find the column which i dont understand

CREATE PROC spBalanceRange
@VendorVar VARCHAR(50) = NULL,
AS
DECLARE @QUERY VARCHAR(1000)
SET @QUERY = 'SELECT VendorName, InvoiceNumber, PaymentTotal AS Balance
FROM Invoices JOIN Vendors
ON Invoices.VendorID = Vendors.VendorID '


IF @VendorVar IS NOT NULL
SET @QUERY = @QUERY + 'WHERE VendorName LIKE ' + @VendorVar + ') '

SET @QUERY = @QUERY + ' ORDER BY PaymentTotal DESC'

EXEC (@QUERY)

 

[Zathras]

Perhaps you meant to say
[tt]
+ 'WHERE VendorName LIKE ' + @VendorVar + '% '
[/tt]

 

[plazmo]

no i just forgot to delete that ')' before posting but more detail on my problem is this:

if i type this:
exec spBalanceRange @VendorVar = 'Vendor'
i get this error:
Invalid column name 'Vendor'.

so if it using a column name:
exec spBalanceRange @VendorVar = 'VendorName'

it runs it.

i dont understand how/why it using a column after my 'LIKE'

 

[r937]

+ 'WHERE VendorName 
         LIKE '''%' + @VendorVar + '''% '

r937.com | rudy.ca

 

[plazmo]

thank you r937 that worked although i used it without the %

it irritates me tho because i tried this once and it didnt work. but works great now thanks again