View Single Post
 
Old May 1st, 2008, 11:13 AM
rgerald rgerald is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Oops, one slight difference. Since @varSKU is an integer, you need to do:

WHERE PD.PromoSKU LIKE '%' + CAST(@varSKU AS varchar(10)) + '%'

Rand