$$$$$$$$$$$$$$$$$How to filter some string start with '%' $$$$$$$$$$$$$$$$$$$$$ 
Author Message
 $$$$$$$$$$$$$$$$$How to filter some string start with '%' $$$$$$$$$$$$$$$$$$$$$

pls any can help me to find how to filter some string start with '%',

since % has already been used as wildcards to match  the last character in
the string or as the first and last character in the string



Sat, 21 May 2005 13:55:52 GMT  
 $$$$$$$$$$$$$$$$$How to filter some string start with '%' $$$$$$$$$$$$$$$$$$$$$
Zhou,

In SQL statement to be able to use any wildcard as an actual character, you
would need to wrap it into brackets

SELECT .... WHERE FieldName LIKE '[%]abc[%]'

Did not try if it works in Filter property of recordset. If not, then you
would need to use SELECT with LIKE to do that

--
Val Mazur
Microsoft MVP


Quote:
> pls any can help me to find how to filter some string start with '%',

> since % has already been used as wildcards to match  the last character in
> the string or as the first and last character in the string



Sat, 21 May 2005 20:29:56 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Common Dialog filter filter's everything

2. Using VB 4.0 with DBF's, CDX's and Setting a Filter

3. unsetting a recordset '.FILTER'

4. Using VB 4.0 with DBF's, CDX's and Setting a Filter

5. Type mismatch: 'Filter'

6. sending the '#' sign through server filter

7. Using VB 4.0 with DBF's, CDX's and Setting a Filter

8. ADODB.recordset filter problem using 'AND'

9. Starting 'find' from Excel

10. qbasic 'redo from start'

11. Run-Time error '20520': Job already started

12. Tables starting 'Sys'

 

 
Powered by phpBB® Forum Software