One extra to add to Mike's answer... lcLast4 = RIGHT(ALLTRIM(m.lcString),4)
>how can i get the last 4 characters of a string, whose length is unknown at design time?
>
>TIA.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown