|
|
|
|
|
| | |
|
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)

|
|
Subject: |
Re: Replace specific character with wildcard |
From: |
J. Paul Schmidt |
Date: |
6/4/2001 1:31:40 AM |
IP: |
152.163.197.54 |
Perhaps try something like this:
strSQL = "SELECT * FROM MyTable WHERE MyFld Like '" & Left(MyVar, 3) & "_" & Mid(MyVar, 5, 4) & "_" & Right(MyVar, 1) & "'"
Best regards,
-Paul
J. Paul Schmidt, MBA
Databases on the Web
http://www.Bullschmidt.com
|
Previous Message
Follow Up - Test - 6/4/2001 1:33:23 AM
|
|
|
|
|
|
|
|
|
|
|
|