LIKE

P

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
 
M

Marshall Barton

PATRICK said:
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]*));
Click to expand...


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

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
Click to expand...

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]
 
Top