How can I strip the first and last character in my string stored in my variable.<BR><BR>For example: my string is 'apples'<BR>but I want it to be just apples<BR><BR>removing the ' from the string? <BR><BR>Jose
strNew = mid(strOld, 2, len(strOld)-2)
This would do it for the example given<BR>MyStr = "'Apples'"<BR>MyStr = Replace(MyStr,"'","")<BR><BR>
You could maybe try using the <BR>Replace(String,find,start,count,comparetype) string function.<BR><BR>I dont know if it'll work but its worth a try
Thanks to all for your help!!!!