Wild Card/Generic retrieval
John Hunter
jthunter@nbnet.nb.ca
Wed, 10 Sep 2003 13:15:18 -0300
This is a multi-part message in MIME format.
------=_NextPart_000_0001_01C3779D.95E21B60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
RE: Wild Card/Generic retrievalNot to be too picky with responses...
but what if the value of partno was '4th6th' ? ie. a value with 2 strings of
th?
then perhaps
> select if 'th' = reverse(reverse(truncate(partno))[1:2])
But I'm not sure if reverse would be more efficient than matchpattern.
-John
-----Original Message-----
If 0 = index(partno,"th") - size(truncate(part-no)) - 1
------=_NextPart_000_0001_01C3779D.95E21B60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>RE: Wild Card/Generic retrieval</TITLE>
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D240445515-10092003>Not to be too picky with=20
responses...</SPAN></DIV>
<DIV><SPAN class=3D240445515-10092003></SPAN> </DIV>
<DIV><SPAN class=3D240445515-10092003>but what if the value of partno =
was '4th6th'=20
? ie. a value with 2 strings of th?</SPAN></DIV>
<DIV><SPAN class=3D240445515-10092003></SPAN> </DIV>
<DIV><SPAN class=3D240445515-10092003>then perhaps </SPAN></DIV>
<DIV><SPAN class=3D240445515-10092003></SPAN> </DIV>
<DIV><SPAN class=3D240445515-10092003>> select if 'th' =3D=20
reverse(reverse(truncate(partno))[1:2])</SPAN></DIV>
<DIV><SPAN class=3D240445515-10092003></SPAN> </DIV>
<DIV><SPAN class=3D240445515-10092003>But I'm not sure if reverse would =
be more=20
efficient than matchpattern.</SPAN></DIV>
<DIV><SPAN class=3D240445515-10092003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D240445515-10092003>-John</SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
size=3D2><FONT=20
face=3DTahoma>-----Original Message-----<SPAN =
class=3D240445515-10092003><FONT=20
face=3DArial color=3D#0000ff> </FONT></SPAN></FONT></FONT></DIV>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
size=3D2><FONT=20
face=3DTahoma><SPAN =
class=3D240445515-10092003></SPAN></FONT></FONT> </DIV>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
size=3D2><FONT=20
face=3DTahoma><SPAN class=3D240445515-10092003> </SPAN></FONT>If =
0 =3D=20
index(partno,"th") - size(truncate(part-no)) - 1</FONT>=20
</DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0001_01C3779D.95E21B60--