> 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]

