10 Jul 2008 at 10:24 #1 Da[]San Da[]San Associate Joined 20 Oct 2002 Posts 1,616 Location North West What is the syntex for finding the last character in a parts table - specifically i want the query to return all records which end in "q". thanks.
What is the syntex for finding the last character in a parts table - specifically i want the query to return all records which end in "q". thanks.
10 Jul 2008 at 10:59 #2 Fezzer Fezzer Associate Joined 12 May 2005 Posts 82 Location Chester Right([FieldName], 1) will give you the last character of a string field if that's what you are looking for.
Right([FieldName], 1) will give you the last character of a string field if that's what you are looking for.
![Da[]San](/styles/overclockers/avatars/4.png){kind=avatar}
