 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
09-08-2008, 09:44 PM
|
|||
|
|||
|
RE: SQL
I would like that field that has more than 8 digits to update another field
to the word "Issue" "tedmi" wrote: > Update to what? > -- > TedMi > > "Noemi" wrote: > > > What is an sql that I can use to update any records that has a field with > > more than 8 digits? 
|
|
09-08-2008, 10:02 PM
|
|||
|
|||
|
Re: SQL
UPDATE MyTable
SET SomeField = "Issue" WHERE Len(SomeOtherField) > 0 -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Noemi" <Noemi@discussions.microsoft.com> wrote in message news:A14BAE94-8F83-4416-BE71-3D6AA03FC871@microsoft.com... >I would like that field that has more than 8 digits to update another field > to the word "Issue" > > "tedmi" wrote: > >> Update to what? >> -- >> TedMi >> >> "Noemi" wrote: >> >> > What is an sql that I can use to update any records that has a field >> > with >> > more than 8 digits?
|
|
09-08-2008, 11:05 PM
|
|||
|
|||
|
Re: SQL
On Mon, 8 Sep 2008 13:44:01 -0700, Noemi <Noemi@discussions.microsoft.com>
wrote: >I would like that field that has more than 8 digits to update another field >to the word "Issue" > UPDATE yourtable SET anotherfield = "Issue" WHERE Len([thatfield]) > 8 -- John W. Vinson [MVP]
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
