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))
 

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

Problem with a select query in Access 2003 1
Count Question 2
Trim in Query Error 1
How to find a gap in sequence of data field 1
TRIM FUNCTION in QUERY 1
TRIM function isn't working in my query 3
Access Access anti-trim?? 0
adding empty spaces to fields? 10

Back
Top