By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 2,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

Function Between alphanumeric

P: n/a
Hello,

I'm trying te maken an update SQL statement. I Use the function
Between And.

The problem is that the values I use by between are alphanumeric. Now
the function between doesn't work. Can anybode tell me how I can solve
this problem.

Thanks,

Marcel
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 16 Sep 2004 06:27:22 -0700, Marcel wrote:
Hello,

I'm trying te maken an update SQL statement. I Use the function
Between And.

The problem is that the values I use by between are alphanumeric. Now
the function between doesn't work. Can anybode tell me how I can solve
this problem.

Thanks,

Marcel

Use >= and <=

Where [FieldName] >="asd123" and <= "zxy987"

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

P: n/a
fredg <fg******@example.invalid> wrote in
news:ds*****************************@40tude.net:
On 16 Sep 2004 06:27:22 -0700, Marcel wrote:
Hello,

I'm trying te maken an update SQL statement. I Use the function
Between And.

The problem is that the values I use by between are alphanumeric. Now
the function between doesn't work. Can anybode tell me how I can solve
this problem.

Thanks,

Marcel

Use >= and <=

Where [FieldName] >="asd123" and <= "zxy987"

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Or, if your VBA works like my VBA (Access97):

Where [FieldName] >="asd123" and [FieldName] <= "zxy987"

I've always disliked having to add that second Reference. <g>

Cheers,
Alan Carpenter
Nov 13 '05 #3

P: n/a
On Fri, 17 Sep 2004 15:11:37 +0000 (UTC), Alan Carpenter wrote:
fredg <fg******@example.invalid> wrote in
news:ds*****************************@40tude.net:
On 16 Sep 2004 06:27:22 -0700, Marcel wrote:
Hello,

I'm trying te maken an update SQL statement. I Use the function
Between And.

The problem is that the values I use by between are alphanumeric. Now
the function between doesn't work. Can anybode tell me how I can solve
this problem.

Thanks,

Marcel

Use >= and <=

Where [FieldName] >="asd123" and <= "zxy987"

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Or, if your VBA works like my VBA (Access97):

Where [FieldName] >="asd123" and [FieldName] <= "zxy987"

I've always disliked having to add that second Reference. <g>

Cheers,
Alan Carpenter


Aha! You got that goof.
Thanks for correcting it.
Yes, it is a shame we have to enter that second reference, but then we
all know computers aren't smart enough to make that leap in logic for
us. :-)
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.