Right Function

[mdr227]

What would the function/syntax be to return the last three characters of a text field?

 

[alsoknownas]

<%=left(RS(&quot;comments&quot,20)&&quot;...&quot;%>

<%=right(RS(&quot;comments&quot,20)&&quot;...%>

<%=mid(RS(&quot;comments&quot,startingpoint,20)&&quot;...&quot;%>



**************************************************************************
This example shows how to use IF else if the field is greater than the value

<%=left(RS(&quot;Name&quot,40)%><%If Len(RS(&quot;Name&quot) > 40 Then Response.Write(&quot;...&quot%>
<%=left(RS(&quot;Description&quot,40)%><%If Len(RS(&quot;Description&quot) > 40 Then Response.Write(&quot;...&quot%>

**************************************************************************

[/tt]

 

[TonyRosen]

if i'm reading your question correctly:

<%
dim strText, strVariable

strVariable = &quot;your text to get this from&quot;
strText = Right(strVariable,3)
response.write strText
%>

 

[vbkris]

hey AlsoKnowAs, i recoginise that cartoon, but cant fix its name (its got this fat moise by its side right?) now what is its name???

Known is handfull, Unknown is worldfull

 

[alsoknownas]

The one one the left if Pinky and the one on the right is the Brain




You know, pinky and the brain

[/tt]

 

[vbkris]

ah!! got it, the pinky and the Brain,brain,brain stuff aint it? i saw it first in cartoon network, i simply love cartoons...

Known is handfull, Unknown is worldfull