Query Subject Calculation

[bpothier]

This is probably so simple but I can;t seem to wrap my head around it.

I have data that will be coming in like this  CA123456 - always CA then 6 numbers
I woudl like to do a calculation to convert it to E012345

Basically change the CA to an E on all the records coming in

Can anyone help

Thanks

[Francis aka khayman]

substring([data,2)

[MFGF]

This is probably so simple but I can;t seem to wrap my head around it.

I have data that will be coming in like this  CA123456 - always CA then 6 numbers
I woudl like to do a calculation to convert it to E012345

Basically change the CA to an E on all the records coming in

Can anyone help

Thanks

You need an expression something like:

'E' + substring([your data item],3,6)

Cheers!

MF.

[bpothier]

Thanks Everyone. You guys always ome through