This worked great. Thank you very much.
>>> Douglas Sims <[EMAIL PROTECTED]> 1/27/2004 12:23:59 PM >>>
It sounds as if you need to use a regular expression.
For very simple string comparisons, use =, as in wbs='Fish'
For more complex string comparisions with simple wildcards, use LIKE as
in wb
It sounds as if you need to use a regular expression.
For very simple string comparisons, use =, as in _wbs='Fish'_
For more complex string comparisions with simple wildcards, use LIKE as
in _wbs LIKE "%fish%"
_For most complex comparisions, use a regular expression, as in _wbs
REGEXP ".\d"_
In
-
Disclamer:
All you do with the suggestion in this mail is you responsibillity even
if your system will crash :)
-Original Message-
From: Jacque Scott [mailto:[EMAIL PROTECTED]
Sent: dinsdag 27 januari 2004 19:57
To: [EMAIL PROTECTED]
Subject: Using Wildcards in Query
I am converting over to mySQL from Access 2.0 and I am having a little
trouble with a query. Here it is:
SELECT Max(WBS) AS LastOfWBS FROM Projects Where((WBS)) Like """ &
txtEntryData(0).Text & "#%"";
I am trying to get the last WBS ID starting with a particular letter
the user will type in th
