Is there a build in function in Access that replace the order of the letters
in a string?
for example: I have a field in a table that has a value "refO"

I would like a function that returns "Ofer"

I have a function that I created, but I'm just wondering if there is a build
in function.
Thanks for your help
Ofer
--
BS"D

StrReverse()

as in...

Private Sub cmdReverseString_Click()

Dim startingstring

startingstring = InputBox("Enter your string")

MsgBox ("Starting String = " & startingstring & Chr(13) & _
"Reverse String = " & StrReverse(startingstring))

End Sub

Ofer Cohen wrote:
> Is there a build in function in Access that replace the order of the letters
> in a string?
> for example: I have a field in a table that has a value "refO"
>
> I would like a function that returns "Ofer"
>
> I have a function that I created, but I'm just wondering if there is a build
> in function.
> Thanks for your help
> Ofer
> --
> BS"D

Thank you,
I had a feeling that such a function exist, but I couldn't remember the name
of it.

Thanks again

--
BS"D


"KML" wrote:

>
> StrReverse()
>
> as in...
>
> Private Sub cmdReverseString_Click()
>
> Dim startingstring
>
> startingstring = InputBox("Enter your string")
>
> MsgBox ("Starting String = " & startingstring & Chr(13) & _
> "Reverse String = " & StrReverse(startingstring))
>
> End Sub
>
> Ofer Cohen wrote:
> > Is there a build in function in Access that replace the order of the letters
> > in a string?
> > for example: I have a field in a table that has a value "refO"
> >
> > I would like a function that returns "Ofer"
> >
> > I have a function that I created, but I'm just wondering if there is a build
> > in function.
> > Thanks for your help
> > Ofer
> > --
> > BS"D
>
>