[dba-VB] dba-VB Digest, Vol 77, Issue 2

That is the correct and simple way of doing it Jack.


At 12:00 PM 3/6/2010, you wrote:
>Date: Fri, 5 Mar 2010 16:30:34 -0500
>From: "Jack and Pat" <drawbridgej at sympatico.ca>
>Subject: Re: [dba-VB] Update without using a view
>To: "'Discussion concerning Visual Basic and related programming
>         issues.'"       <dba-vb at databaseadvisors.com>
>Message-ID: <BLU0-SMTP1339B6A9049F0FAAA888F6C4380 at phx.gbl>
>Content-Type: text/plain;       charset="us-ascii"
>
>John,
>Glad you  solved it.
>
>I'm curious, and I don't use Sql server, but why wouldn't this work
>
>UPDATE dbo.AZSMKRevalidate SET zip5 = Left([zip9],5), zip4 =
>Right([zip9],4);
>
>jack