Re: [Emerald] SQL QUERY

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

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.

For more information about this list (including removal) go to: