a few ways to obtain the last two elements of a field: MID(MYFIELD,3,2): Meaning Start at the 3rd character and grab the next two
RIGHT(MYFIELD,2) Obtains the last two characters of the string >>> [EMAIL PROTECTED] 06/24/02 02:11PM >>> I have a control year I need to trim the first 2 digits off of it inorder to use the last 2 in a date.... How can I do this? ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
