Hi all,
Having done lots of searching on the net and trying out of SQL this problem has driven me mad, I need to strip certain pieces of information from a value held in a field in SQL in order to perform a calcuation on the remaining value.
E.G.
The original value - 024967626936
What I need - 496762693
Does anyone have any ideas how I can go about doing this?
Many thanks in advance
Jez
Having done lots of searching on the net and trying out of SQL this problem has driven me mad, I need to strip certain pieces of information from a value held in a field in SQL in order to perform a calcuation on the remaining value.
E.G.
The original value - 024967626936
What I need - 496762693
Does anyone have any ideas how I can go about doing this?
Many thanks in advance
Jez