<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
Access:<br />
Table: &nbsp;tbl_import<br />
<br />
Field1 -text<br />
<br />
I need an update query that will strip leading zero if it exists at the beginning of a string..<br />
The total string should be 9 characters.<br />
Sometimes I have a people putting a leading zero.<br />
<br />
0823176885<br />
it needs to be<br />
823176885<br />
<br />
0856340980<br />
need to be<br />
856340980<br />
<br />
thanks <br />
fordraiders
</div>
</div>


Access:
Table:  tbl_import

Field1 -text

I need an update query that will strip leading zero if it exists at the beginning of a string..
The total string should be 9 characters.
Sometimes I have a people putting a leading zero.

0823176885
it needs to be
823176885

0856340980
need to be
856340980

thanks 
fordraiders

strip leading zero after pasting data or do an update query to get rid of leading zero

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.