Listed below is my stored procedure, when I run the stored procedure using
asp, I get no results. The problem is the last variable passed, has two
words separated by a space. If I pass a variable with one word I get
results.
Any help would be appreciated.


REATE PROCEDURE [dbo].[getAppLargeImg] @sSubBrand nvarchar(255),
@sApplication_Type nvarchar(255), @sApplication_Category nvarchar(255) AS
SELECT PL_Family_Images.Status,
PL_Family_Images.SubBrand,
PL_Family_Images.Family,
PL_Family_Images.Category,
PL_Family_Images.Caption,
PL_Family_Images.FileName,
PL_Family_Images.Path,
PL_Family_Images.Image_Type,
PL_Family_Images.App_Type,
PL_Family_Images.App_Category,
PL_Family_Images.Image_Sequence
FROM PL_Family_Images
WHERE PL_Family_Images.Status='A'
AND PL_Family_Images.SubBrand=@sSubBrand
AND PL_Family_Images.Image_Type='App_Large'
AND PL_Family_Images.App_Type=@sApplication_Type
AND PL_Family_Images.App_Category=@sApplication_Type
AND PL_Family_Images.Image_Sequence=1