Trim specified characters from Left (in SQL)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not able to remember the function name. What I am looking to do is to
truncate 2 characters from left side. PartNumber field contains data like
PT682U
PT1652
PTX966 etc.

I would like to truncate/remove "PT" and list it like
682U
1652
X966 etc.

Help.
- Vijay
 
That's the function I was looking for. Thanks.
- Vijay

Van T. Dinh said:
Mid([YourField],3)

--
HTH
Van T. Dinh
MVP (Access)


Vijay said:
I am not able to remember the function name. What I am looking to do is to
truncate 2 characters from left side. PartNumber field contains data like
PT682U
PT1652
PTX966 etc.

I would like to truncate/remove "PT" and list it like
682U
1652
X966 etc.

Help.
- Vijay
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim Time off Date 4
need help removing zeros with Left or right?? 3
Unusual reason for Memo truncation 2
sql and truncating field on export 1
return specific character read from right to left 0
Truncating Results 10
Left Function? 2
Trim String 9

Back
Top