LIKE

  • Thread starter Thread starter PATRICK
  • Start date Start date
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
 
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] & "*"
 
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]
 
Back
Top