LIKE

[PATRICK]

How do I refer to an actual field within a LIKE statement


for example

PARAMETERS BITIWANT TEXT;
SELECT WHATEVER FROM WHEREVER WHERE ((WHEREEVER.THEONE)
LIKE *[BITIWANT]*));


THIS DOESNT WORK

PATRICK

 

[Marshall Barton]

How do I refer to an actual field within a LIKE statement


for example

PARAMETERS BITIWANT TEXT;
SELECT WHATEVER FROM WHEREVER WHERE ((WHEREEVER.THEONE)
LIKE *[BITIWANT]*));

.... WHEREEVER.THEONE LIKE "*" & [BITIWANT] & "*"

 

[John Vinson]

How do I refer to an actual field within a LIKE statement


for example

PARAMETERS BITIWANT TEXT;
SELECT WHATEVER FROM WHEREVER WHERE ((WHEREEVER.THEONE)
LIKE *[BITIWANT]*));


THIS DOESNT WORK

Concatenate the wildcards as strings:

PARAMETERS BITIWANT TEXT;
SELECT WHATEVER FROM WHEREVER WHERE ((WHEREEVER.THEONE)
LIKE "*" & [BITIWANT] & "*"));

<love your example names!>

John W. Vinson[MVP]