I am using SQL Server 2000
this statement gives me this error "Incorrect syntax near the keyword 'AND'".
DECLARE @TERR1 VARCHAR(15)
SET @TERR1 ='RM1'AND'RM2'AND'RM4'
SELECT RP.TERR1
FROM dbo.REP_PROFILE RP
WHERE RP.TERR1 =@TERR1
I can get this to work for single item but not for multiples.
Doesnt like <IN> either.
DECLARE @TERR1 VARCHAR(15)
SET @TERR1 ='RM1'
SELECT RP.TERR1
FROM dbo.REP_PROFILE RP
WHERE RP.TERR1 =@TERR1
this statement gives me this error "Incorrect syntax near the keyword 'AND'".
DECLARE @TERR1 VARCHAR(15)
SET @TERR1 ='RM1'AND'RM2'AND'RM4'
SELECT RP.TERR1
FROM dbo.REP_PROFILE RP
WHERE RP.TERR1 =@TERR1
I can get this to work for single item but not for multiples.
Doesnt like <IN> either.
DECLARE @TERR1 VARCHAR(15)
SET @TERR1 ='RM1'
SELECT RP.TERR1
FROM dbo.REP_PROFILE RP
WHERE RP.TERR1 =@TERR1