|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Replace specific character with wildcard |
|
From: |
MikeS |
|
Date: |
6/1/2001 9:34:04 PM |
|
IP: |
4.41.78.7 |
Forgive me as I am new to this whole asp, database, vb...thing... I have an Access database the contains a ten character ID. The query should be simple, except at times the fourth character is an "&" and always the ninth character is an "&". I need to replace the ampersand with a wildcard (either "_" or "?")I tried a left and mid function query that worked in Access but bombed in ASP (don't know why).
I also suspect there would be an easier way to say "if in string "&" replace with (?).
How would you do that? Or, any ideas what the differences would be in syntax between left function, mid function in Access or ASP?
Any ideas would be appreciated. |
Follow Up - Re: Replace specific character with wildcard - J. Paul Schmidt 6/4/2001 1:31:40 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
