Re: [Emerald] SQL QUERY

Dale E. Reed Jr. ( (no email) )
Fri, 04 Feb 2000 22:59:56 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: wilson@dagupan.com: "RE: [Emerald] URGENT: Billing Oddities"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Creating an email account automatically"
Maybe in reply to: PowerNet: "[Emerald] SQL QUERY"

Kenneth Gustav Eitenmiller Jr wrote:
>
> Looks good, but differentiates zip codes between 61111 and 61111-1111.
> Is there a way to trim all charaters after the first 5 in the zip code
> field?

Use Left(Zip,5) with SQL7 to replace Zip

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart

Previous message: wilson@dagupan.com: "RE: [Emerald] URGENT: Billing Oddities"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Creating an email account automatically"
Maybe in reply to: PowerNet: "[Emerald] SQL QUERY"