|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Wildcards in SQL statements |
|
From: |
Ricardo Londe |
|
Date: |
3/10/2000 7:08:06 AM |
|
IP: |
200.244.42.1 |
I guess that you are trying to search for partial string inside the Mfg field. You should try this SQL statement:
SQL="SELECT manTBL.Mfg FROM manTBL
WHERE (((manTBL.Mfg) Like %" & targetString & "%))"
The ampersand (&) is the correct wildcard char. I use one & at the beginning and another at the end to select all the ocurrences of targetString in the field. Please, dont forget to use the to delimit the string in the sql statement.
I hope this helps.
Ricardo Londe
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
