Mid or Left in SQL Command

[Llazwas]

I'm using Crystal 10 with a ProvideX database and trying to extract a portion of a string using a SQL command but can't get it to work. I need to use a command to resolve a linking problem.

My table contains an item.tranID like below:

R0012342
R0983745
R5789098

I need my SQL command to drop the leading digit and return the field like:

0012342
0983745
5789098

I've tried a few different commands but can't get it to work. Any assistance is greatly appreciated.

 

[Turkbear]

Hi,
The docs here:

http://manual.pvxplus.com/

indicate that you can use MID(string,start) so
MID({Table.Field},2) should do it.





To Paraphrase:"The Help you get is proportional to the Help you give.."