I'm struggling with a "simple" RegEx problem. I wan't to check a sting if the pattern "BN123456" or "bn123456" is included and if so, extract it. The pattern could be in the beginning, middle or end of the string. So I setup this regex and this test code Pattern MyPattern = Pattern.compile('[Bb][...

I am writing some code to automatically ALTER COLUMN dimensions in a target table where neccessary to accomodate the data of a source table prior to INSERTing into it. For example, say I have a source table containing a column called ABC defined as VARCHAR(10). I have a target table with that col...