I'm trying to use a regular expression in the lastposition and substring functions to separate a word into two values based on where the A-Z ends and the numbers begin:
CAPMO0330201400 needs to be CAPMO & 0330201400
I thought the first substring would work like this:
ok, well then that's a feature request! And/or is there a way in a ModifyRowset to split a column in to two columns separating the alpha from the numeric? If not, I can do this in the SQL.