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...
 
Back
Top