View Single Post
 
Old May 1st, 2008, 10:20 AM
joefawcett's Avatar
joefawcett joefawcett is offline
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

I would do:
Code:
DECLARE @Search NVARCHAR(20);
SET @Search = '%' + CAST(@intSKU AS NVARCHAR(15)) + '%';
SELECT .... WHERE PD.PromoSKU LIKE @Search....
--

Joe (Microsoft MVP - XML)