Solved

left function and append

Posted on 2009-05-18
3
191 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

This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

822 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