left function and append

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
BrogrimInformation Systems Development ManagerAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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
 
Rey Obrero (Capricorn1)Commented:
update tableX
set fld1=Left([fld1],1) & "0" & mid([fld1],2)
0
 
Rey Obrero (Capricorn1)Commented:
Brogrim,

Looks like you did not see my post....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.