Trim first two left characters in a field

  • Thread starter Carlton A. Barlow
  • Start date
C

Carlton A. Barlow

I need to trim the two charactesr from a field. If you have a simple sql
statement that would be great too.
 
T

Tom Wickerath

Hi Carlton,

How about this:

SELECT Mid$([FieldName],3) AS [Trimmed Field]
FROM TableName;

Tom
___________________________

:

I need to trim the two charactesr from a field. If you have a simple sql
statement that would be great too.
 
Top