shortening of a string

  • Thread starter HENDRY_del_FUEGO
  • 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!
 
J

John Spencer

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