Solved

left function and append

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

Expert Comment

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

Accepted Solution

by:
Raja Jegan R earned 500 total points
Comment Utility
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 119

Expert Comment

by:Rey Obrero
Comment Utility
Brogrim,

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

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

771 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now