Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
03-22-2007, 08:36 PM #1
- Join Date
- Sep 2006
- Skopje, Macedonia
- Thanked 0 Times in 0 Posts
Access database replace characters
Hi i have access database and i want to search it through my web page but the problem is that I cannot use the character replace (*) for replacing one, more or zero characters. I also tried with % from SQL but doesn't work. Can you help with this?
Best regards, Lallo
03-23-2007, 08:11 PM #2
- Join Date
- Jun 2005
- Near Chicago, IL, USA
- Thanked 32 Times in 31 Posts
The * should work for Jet (Access).
Are you getting an error, or just incorrect matches?
Is this a string (text) field, a number, or date?
What was the exact query, including any single/double quotes?
If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
Bored? Visit http://www.kaelisspace.com/