hi,
im trying to make a query with variables. in sql this is no problem but in sap it is. cause i want to use [%0] in my query
this is my query:
declare @Name as varchar(100)
SET @Name = [%0]
SELECT dbo.OCRD.CardCode AS Klantcode, dbo.OCRD.CardName, dbo.OCPR.Name AS Naam, dbo.OCPR.E_MailL AS Email, dbo.OCPR.U_Voornaam AS Voornaam,
dbo.OCPR.U_Achternaam AS Achternaam, dbo.OCRD.Address AS Straat, dbo.OCRD.ZipCode AS Postcode, dbo.OCRD.City AS Plaats, dbo.OCPR.Tel2 AS MobielNummer,
dbo.OCRD.Phone1 AS Bedrijfsnummer
FROM dbo.OCRD INNER JOIN
dbo.OCPR ON dbo.OCRD.CardCode = dbo.OCPR.CardCode
WHERE dbo.OCPR.Name LIKE '%' + @Name + '%'
also tried:
SELECT dbo.OCRD.CardCode AS Klantcode, dbo.OCRD.CardName, dbo.OCPR.Name AS Naam, dbo.OCPR.E_MailL AS Email, dbo.OCPR.U_Voornaam AS Voornaam,
dbo.OCPR.U_Achternaam AS Achternaam, dbo.OCRD.Address AS Straat, dbo.OCRD.ZipCode AS Postcode, dbo.OCRD.City AS Plaats, dbo.OCPR.Tel2 AS MobielNummer,
dbo.OCRD.Phone1 AS Bedrijfsnummer
FROM dbo.OCRD INNER JOIN
dbo.OCPR ON dbo.OCRD.CardCode = dbo.OCPR.CardCode
WHERE dbo.OCPR.Name LIKE '%%[%0]%%'
nothing works,
hope someone can tell me how to do this.
many thanks,
kind regard and best wishes 2008
Coen Oude Luttikhuis