I have written a stored procedure for MSSQL 2000 procedure search_result(@name VARCHAR,@address varchar)
AS
IF((@name IS NOT NULL AND @name <> '' AND @name <> ' ') AND(@address IS NULL OR @address <> '' OR @address <> ' '))
BEGIN
SELECT [postal_code]
FROM OM
WHERE [name] LIKE '%@name%'
END
.....
GO
Nothing is being returned I have tried it in the query analyzer
AS
IF((@name IS NOT NULL AND @name <> '' AND @name <> ' ') AND(@address IS NULL OR @address <> '' OR @address <> ' '))
BEGIN
SELECT [postal_code]
FROM OM
WHERE [name] LIKE '%@name%'
END
.....
GO
Nothing is being returned I have tried it in the query analyzer