Posted by Robert Klemme on 01/12/06 19:54

tgru wrote:
> The issue there is that the numbers are of varying lengths, and it
> might not always just be a single quote at the end. So, I was hoping
> to be able to just extract the numerics without having to deal with
> positions and length of the numeric portion. I.e. why can't I just
> grab alpha or numeric or non alpha numeric from the whole string??
> :-) Seems like that should be easier to do than it is...

You can for example use charindex to find the terminating single quote.

You cal also install Oracle 10 which supports regular expressions.
Honestly, is this stored in the DB? If so, I'd try to make it two columns
if possible.

HTH

robert

[Back to original message]