shortening of a string

  • Thread starter Thread starter HENDRY_del_FUEGO
  • Start date Start date
H

HENDRY_del_FUEGO

can anybody help me with the following problem:

I need an update query which shortens a string (the item) to maximum 18
characters.

Some items are 19 others are 20 .... characters long.

How can I do this?

thanks for your time!
 
LEFT([SomeValue],18)
will return the first 18 characters of SomeValue. If the SomeValue is
shorter than 18 characters it will return the entire string.


For other options look at Right and Mid functions.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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

limit character count 1
QueryDef.SQL Limit? when trying SQL PassThrough 7
Convert Some field Entries to negative Numbers 2
Replace or insert characters in text string 6
pass-through query ODBC connect str error? Version: 2003 (11.0) 1
Need to determine length of field for query 1
Remove text string 2
max size command line argument 1

Back
Top