I wanted the results to begin with the search keyword, Wrapping the variable in %% would produce too many vague results.
Thanks, Dave Bosky -----Original Message----- From: Michael McManus [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:15 AM To: SQL Subject: RE: T-SQL Stored Procedure like syntax Perhaps try using like '%@SearchKeyword%' -----Original Message----- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 8:17 AM To: SQL Subject: T-SQL Stored Procedure like syntax I'm trying to use a basic search but it never returns matching records. I know I must be missing something simple but I'm new to using SP's. ---------------- CREATE PROCEDURE dbo.spSupplyInformation @SearchKeyword varchar (100) AS SELECT site_id,usage_code,item_id,item_descp,commodity_code,unit_of_measure, stockroom_id,bin_id,on_hand_qty,minimum_qty,maximum_qty,reorder_qty FROM dbo.tbl_Elec_Req WHERE item_descp like '@SearchKeyword%' GO --------------- Thanks, Dave ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
