Solved

left function and append

Posted on 2009-05-18
3
192 Views
Last Modified: 2013-11-29
I have changed the value from 6 - 7,

Former W71234 has become W712340 instead of W071234

What query would put the 0 in front of the W instaed of at the end?left function and append
0
Comment
Question by:Brogrim
  • 2
3 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24411903
update tableX
set fld1=Left([fld1],1) & "0" & mid([fld1],2)
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 24411904
Left function worked correctly by providing W712340 as the output.

<< What query would put the 0 in front of the W instaed of at the end?left function and append  >>

Try this one out:

Left(<FieldName>, 1) & "0" & Mid(<FieldName>, 2, 6)
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24411998
Brogrim,

Looks like you did not see my post....
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question