Skip to Content
0
Jan 02, 2008 at 11:12 AM

problem with query

25 Views

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