<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><SPAN class=024454414-03022003>Terri</SPAN></DIV>
<DIV><SPAN class=024454414-03022003></SPAN> </DIV>
<DIV><SPAN class=024454414-03022003>Use the Right function. I'm never sure which
way the syntax goes but it's something like</SPAN></DIV>
<DIV><SPAN class=024454414-03022003></SPAN> </DIV>
<DIV><SPAN class=024454414-03022003>Right([string],6)</SPAN></DIV>
<DIV><SPAN class=024454414-03022003></SPAN> </DIV>
<DIV><SPAN class=024454414-03022003>Roz</SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma>-----Original Message-----<BR><B>From:</B> Terri Jarus
[mailto:jarus@amerinet-gpo.com] <BR><B>Sent:</B> 03 February 2003
14:22<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Parsing Strings<BR><BR></FONT></DIV>
<DIV>I know this is very easy, but I can never remember exactly how to do
this. I need to parse off some data from the end of a string. For
example, the string:</DIV>
<DIV> </DIV>
<DIV>FLDR T TAB M CLIP#5 BLUE 11PT; 2 PLY STRAIGHT CUT 250/CS</DIV>
<DIV> </DIV>
<DIV>I want to parse out "250/CS". How do I set up the code to do
this? This info is always going to be at the end of the string.
</DIV>
<DIV> </DIV>
<DIV>Thanks for your help. If there is a website or information that I
can put in my files as to how to work with strings, I could reference that in
the future.</DIV></BLOCKQUOTE></BODY></HTML>