You can use Left, Right and Mid to extract parts of a string. However, if you
want to remove characters at a random point, wouldn't Replace be better?
Replace(yourString, "%20", "")
> I need to remove the characters '%20' from a string (at a random
> point). I have done this before using a count where you split the
> string on the count to examine each character, however this was not in
> Can anyone help either with a soloution or a command where you can
> split the string at set characters i.e. something like splistring(1,2)
> for example.