Trim Query

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

Guest

I am trying to create a query that takes a field (i.e township) that contains
a value such as 46N and I want to replace that value in field township
without the right most character. (i.e. 46N becomes 46) Some value however
have a space such as 46 N. It will always trim the rightmost 1 character.
Any ideas on how to do it?
 
BIll Mills said:
I am trying to create a query that takes a field (i.e township) that contains
a value such as 46N and I want to replace that value in field township
without the right most character. (i.e. 46N becomes 46) Some value however
have a space such as 46 N. It will always trim the rightmost 1 character.
Any ideas on how to do it?
Click to expand...

UPDATE some_table SET township = Trim(Left(township,Len(township)-1))
 
Back
Top