String manipulation

[maxl]

I've got a string in wich I need to get rid of the last character only if it's a "C" and the string is of variable lenght anybody can help? thanks

[jim mcnamara]

if right(mystring,1) = "C" then
       mystring = left( mystring,Len(mystring))
end if

[shragel]

if right(mystring,1) = "C" then
       mystring = left( mystring,Len(mystring)-1)
end if

You forgot the -1

[Freshwater]

Think you missed the -1 off the end