Below is the expression to be evaluated:
Substring (@Variable,1, (FINDSTRING( @Variable,"Full_", 1)-2))
@Variable is the variable containing the exact string 'Archive_Full_20120731200003'
But when i used this as a expression, it gives the error that substring does not allow -ve integer values.
Kindly help.