That is off the top of my head, so it may be slightly wrong. See the
Access manual for more information on function syntax.
-Matt
On Feb 16, 2004, at 4:21 PM, Bob Haroche wrote:
> Matt Liotta wrote:
> > If all the zip codes are 5 digits then you can just split the
> > string at
> > length - 5.
>
> Yes, good, but what is the SQL code for achieving that, assuming the
> field/column is currently called "city"?
>
> -------------
> Regards,
> Bob Haroche
> O n P o i n t��S o l u t i o n s
> www.OnPointSolutions.com
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
